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.
N985SHAlamo Flight Academy LLC · San Antonio, TXN985TGGregorski Thomas E · Kenly, NCN985WWuya Charlene F · Bethel, AKN986Waterman David K · Temple City, CAN98606Fawcett Walter L Jr · Wolfeboro, NHN9860GCitabria Inc · Auburn, CAN9860QKennedy Roxanne L · Half Moon Bay, CAFirst renewal noticeN9860WCalkins Ray · Socorro, NMN9861CBell Richard H · Blairsville, GAN9861GLaurel Highlands Aeronautical Academy · Latrobe, PAN9861QFallon Muni Flyers LLC · Fallon, NVN9861UWalther Joseph A · Aledo, TXN9862AAstrup Lloyd H · Mesa, AZN9862HTaf Aerial Services LLC · Beeville, TXN9862JNew River Flying Club Inc · Beaver, WVN9862UFearn Mickey M · Idaho Falls, IDN9862WWagler Randal Clarence · Bradenton, FLN98637United States Air Force Owner · Elmendorf Afb, AKN9863GHurricane Airshows Inc · La Porte, TXN9863LAspire Aviation LLC · Farmingdale, NYN9863UHedin John A · Charlotte, NCN9863WRohde Bruce G · Fife, WAN98646Seitz David · Gordonville, TXN9864CAerowest LLC · Wilmington, DEN9864GHoppers James W Jr · Milan, TNN9864LCivil Air Patrol Inc · Maxwell Afb, ALN9864QWayman Keith · Longmont, CON9864USiegrist Dean P · Tarpon Springs, FLN9864WDuell David J · Sparks, NVN98651Milton Aviation Inc · Mohegan Lake, NYN98652Bartron J Stark III · Tunkhannock, PAN9865GWheeler John W · River Ranch, FLN9865LCox Justin E · Albuquerque, NMN9865VPierce Aero LLC · Moore, SCN9865YCloose Brian D · Carlton, MNN98667Wuestenflug LLC · Phoenix, AZN9866G198 Main Street Aviation LLC · Sullivan, WIN9866JKembel Robert D · Saint Ignatius, MTN9866LNo Limits Aviation · Hayden, IDN9866UFell Vincent · Lubbock, TXN9866YMummey Gary E · Stockport, OHN9867DStewart Jacob A · Turner, MTN9867GRegistration Pending · Miami, FLRegistration pendingN9867JNorby Aviation LLC · Hopkinton, MAN9867LHubbard Christopher Thomas · Myrtle Beach, SCN9867QJohnson Barney · Belleville, ILN9867WBeuscher Sharon A · Fairborn, OHN9867YPeterson Eric S · North Logan, UTN98684Aviator Air Operations LLC · Grand Prairie, TXN9868DCub Crafters Services LLC · Yakima, WA
Back to AD 81-18-04 R2