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.
N987SCJuliet Charlie Aviation LLC · Oregon City, ORN987SLBell Steven C · Lamesa, TXN987TReady Aim Flyer LLC · New Castle, DEN987TDRegistered aircraftN9880GHewlett John · Columbus, OHN9880HAbell Alan R · Elgin, ILN9880LTrinity Property Management LLC · Corvallis, ORN9880QAircraft Resource Center Inc · Lakeville, MNN9880WJuhl Aaron · Overland Park, KSN9880YMerrick Shane · Redgranite, WIN98811Kadena Aero Club · Apo Ap, CAN98819Oxford Flying Club Inc · Oxford, CTN9881GFortenberry Robert N · Pascagoula, MSN9881KHickman David R · Port Orange, FLN9881LFerrell D R · Stockton, CAN9881PSale Reported · Spartanburg, SCSale reportedN9881QSky Drivers LLC · Lavalette, WVFirst renewal noticeN9881UChristensen Myra J Storms · Pierre, SDN9881VShackleford Developments Of Sc LLC · Mount Pleasant, SCN98824Civil Air Patrol Inc · Maxwell Afb, ALN9882DUsda Aphis Ws Atoc · Cedar City, UTN9882UNordbye Newell · Eden Prairie, MNN9883Whitehurst James G III · Charlotte, NCN9883GLagor Mark D · Parshall, NDN9883PMinden Soaring Club Inc · Minden, NVN9883UPars Avn Corp · Wilmington, DEN98840Aviator Air Flight School LLC · Grand Prairie, TXN98843American Patrols Inc · Midland, TXN9884DMartensen Marten · Anchorage, AKN9884GBarbour John P · Dexter, MON9884LGaston Stephen J · Saint James City, FLN9884PVandegriff Cody E · Eagle River, AKN9884VShockley James F · Loves Park, ILN9884YRoberts Colton C · Bluebell, UTN98851Jacques Jerry Joseph · Iliamna, AKN98853Registered aircraftN9885DBarney Jeff S · Fairbanks, AKN9885FSky View LLC · Madison, MSN9885PTriple Cub Aviation LLC · Greenbush, MIN9885QAngel Aviation Inc · Peoria, AZN9885USchneider Fred M Jr · Fishkill, NYN9885VNix Jacob DBA · Johnson, KSN9885YCentral Air Parts Inc · Staunton, ILN9886CAlm Ronald · Kuna, IDN9886KSmart03 LLC · Kissimmee, FLN9886NHall Benton G · Plano, TXN9886VBognar John W III · Sardinia, NYN9886WLathem Emma K · Amarillo, TXN98873Laguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeN98875Breun David J · Albuquerque, NM
Back to AD 81-18-04 R2