AD 81-18-04 R2
Registered aircraft · 81,733
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N831BBVentec LLC · Fort Lauderdale, FLFirst renewal noticeN831BFHuddleston Edward L · Oaktown, INN831BRAir Future Airways Corp · Miami, FLN831DBN831db LLC · Canby, ORN831EREmbry Riddle Aeronautical University · Daytona Beach, FLN831GBDievendorf Gerry T · Columbia, SCN831GRGrahn James A · Las Vegas, NVN831JNErlanger Joshua · Jupiter, FLN831JRRegistration Pending · High Springs, FLRegistration pendingN831KTPilot Network Flyers LLC · Bastrop, TXN831KXRkm Leasing LLC · Greenwich, CTN831LBWedekemper Steven E · Brighton, MIN831MAState Of Wisconsin · Madison, WIN831MNSallee William T · Sylvania, OHN831NDCirrus Aviation Inc · Sarasota, FLN831NQEslinger Carl W · Chouteau, OKN831PMAvier LLC · Beverly, MAN831RHHanson Paul D · Evansville, INN831SSmith James A Trustee · Cheyenne, WYN831SHHutchison Eugene W · Armagh, PAN831TSWingsleasing LLC · Wichita, KSN831VZMelbourne Flight Training LLC · Melbourne, FLN83208Rothrock Cara J · Streator, ILN8320AMendez Leonel Jr · Corpus Christi, TXN8320CRiffle Bruce H · Chesterton, INN8320VThurman Randall N · Mcminnville, ORN8320WOracle Aviation LLC · Omaha, NEN8320YKling Aviation Inc · Friendswood, TXN83210Chapman Jeremy · Niagara Falls, NYN83212Salty Flights LLC · Labelle, FLN83213P-R Aircraft LLC · Snellville, GAN8321CJackson Blane · Beaufort, NCN8321HJust Plane Fellas LLC · Omro, WIN8321LArevalo Gilbert Jr · Loranger, LAN8321MFox Two LLC · Camino, CAN8321PSmoketown Helicopters LLC · Smoketown, PAN8321RThompson Grady R · Athens, ALN8321TRobinson Denise · Middletown, CTN8321WWeighman David R · Battle Creek, MIN8322EHorton Ernest J III · Galveston, TXN8322SAtp Aircraft 4 LLC · Wilmington, DEN8322V11 Point Aviation LLC · Alton, MON8322WLickteig Eric Kirk Trustee · Ellensburg, WAN8322YDayhoff Miller Alice J · Springfield, OHN83231Padilla Rafael R · Monee, ILN8323AWisconsin Aviation Inc · Watertown, WIN8323BMidcoast Helicopter Services Inc · La Ward, TXN8323FDavis William · Texarkana, TXN8323VToczek Keith E · Yankton, SDN8323WConcord Aviation Services LLC · Concord, NH
Back to AD 81-18-04 R2