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.
N9473DZweifel Douglas L · Anchorage, AKN9473JEncounter Inc · Piedmont, OKN9473VBarcus Roger L · Saint Paul, MNN9473WRohrer Stephen B · Decatur, GAN9473ZGoldstein Jeffrey Edward · Dix Hills, NYN9474BDiehl Greg · Angola, INN9474JGerber Dennis J · Liverpool, NYN9474NA-G-E Corp · Fort Pierre, SDN9474VCasa Patrick Greg · Albuquerque, NMN9474WGoines Russel D · Highland, CAN9475DRoe Dennis N · Fairbanks, AKN9475EBerzinis Wayne T · Windham, MEN9475FLewis Steve · Canyon, TXN9475PGorin Eugene · Cedar Grove, NJN9475TJohnson Marc · Westland, MIN9475WGiese Aerial Inc · Hoffman, MNN94768Indian River Flying Club Inc · Rockledge, FLN9476FF & M Miya LLC · Hanford, CAN9476HHelicopter Partners Inc · Wellington, FLN9476JNery Thomas A · Mansfield, MAN9476LJohnson Nicholas J · Cantonment, FLN9476NScheigert Delbert F Jr · Tucson, AZN9477DJ H Miller & Son Inc · Saint John, WAN9477JMatthews Byron Kim · Hooper, UTN9477LSlipstream Aviation LLC · Carrollton, GAN9477VMurnville Glenlove Flyers Ltd · Delaware, OHN9477WBaker John E · Westfield Center, OHN9478LWeaver Iann · Polk, OHN9478NChadwick Aviation Services LLC · Monroe, CTN9478WAmerican Aircraft Sales LLC · Lincolnshire, ILN94790Kingsky Flight Academy LLC · Lakeland, FLN9479DGrote Neal Scott · Harrison, NEN9479TSouthern Colorado Flight Professionals LLC · Pueblo, CON9479WSchacher Daniel E · Muleshoe, TXN947AFAmeriflyers Of Texas Inc · Addison, TXN947ARPapoi Coral A · Sitka, AKN947CPCivil Air Patrol · Maxwell Afb, ALN947KCPeterson Cassandra L · Poplar Grove, ILN947MRonneburger Brian · Northport, NYN947RWWorkman Ron L · Lenoir City, TNN947SFSnohomish Flying Service Inc · Snohomish, WAN947TESkyway V LLC · Naples, FLN947TTPucciariello Alexander A · Punta Gorda, FLN947VATextron Aviation Inc · Wichita, KSN9480CDave Gross Inc · Midland, TXN9480DKent State University · Stow, OHN9480EMoyer Aviation Inc · Tobyhanna, PAN9480HMoynihan Patrick J · Lakeville, MNN9480J217 Moriarty LLC · Stonewall, MSN9480RWestern Montana Orthopaedic LLC · Missoula, MT
Back to AD 81-18-04 R2