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.
N96092Florida Flyers Flight Academy Inc · Saint Augustine, FLN96096Jwa Flight School LLC · Bolingbrook, ILN9609HWilliams Marc A · Fallon, NVN9609JAdams Donald J · Lock Haven, PAN9609PMerlin Aviation Inc · Moriarty, NMN9609QWestrup Gregory W · Greensburg, INN9609VFly Fly Fly LLC · Dover, DEN9609WCullen Michael R · Fort Mohave, AZN960ACNaples Air Center Inc · Naples, FLN960AUAuburn University · Auburn, ALN960CPCivil Air Patrol · Maxwell Afb, ALN960DGN960dg LLC · Idaho Falls, IDN960DSDelta State University · Cleveland, MSN960FSSouthern Aero LLC · Homestead, FLN960GSStevens Chad M · Huntsville, ALN960KMMorris Ag Air And Sons Inc · Orovada, NVN960MSMt San Antonio Community College District · Walnut, CAN960ROpar Lauren · Morrisville, NCN960RMCag International Inc DBA · Longmont, CON960RSSouthard James E Jr · Charleston, SCN960RVHouse Gregory E · Sealy, TXN960TAInnoutaero LLC · Stockton, CAN960TEBeauregard Timothy · Haslet, TXN960VSSauder Philip J · Peninsula, OHN960WCStardust Aviation LLC · Farmingdale, NYN96100Trajectory Aviation LLC · Hollywood, FLN96105Demon Air LLC · Palm City, FLN9610BGoodman Aviation LLC · Choteau, MTN9610CHageman Theron · Jay Em, WYN9610DHicks Joseph O · Germanton, NCN9610QUS Aviation Group LLC · Denton, TXN9610RReynolds Kirk S · Skaneateles, NYN9610SLake A Randy · San Diego, CAN9610UMaschek Anthony Q · Harker Heights, TXN9611CSamrat Prithviraj Inc · Miami, FLN9611JStull Donald K · Catawba, NCN9611MElectron Neutrino Inc · Lewes, DEN9611UKingsley Paul A II · Idledale, CON9612DSoto Edward · Wasilla, AKN9612HRegistration Pending · Ocean Isle Beach, NCRegistration pendingN9612JReich Gregory N · Schwenksville, PAN9612LSolomon Michael G · Dallas, GAN9612UElizabeth B Hawley · Wichita Falls, TXN9612VLe Roux Rocco · Carlsbad, CAN9612WJama Aviation LLC · Blaine, MNN9613AHamiter Trace A · Auburn, ALN9613HFiedler Mark · Wichita, KSN9613JKraun Fred M · Fall City, WAN9613LPederson Patrick D · Cotati, CAN9613MLeland Erik J · Beaverton, OR
Back to AD 81-18-04 R2