AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N4809NNewland John G · Eagle, IDN4809USchutze Curt K · Santa Paula, CAN480SCZephyr Services LLC · Long Beach, CAN4810YInternational Air Services Inc Trustee · Carson City, NVN4811DAbidance Inc · Winthrop, WAN4811NMiller Edwin C · Proctor, WVN4811USwartz Ryan W · Pierre, SDN4812CRennekamp Eric J · Andersonville, TNN4812FNorth American Aerial Surveys LLC · Tucson, AZN4812UFoster Frank Brian · Goldsboro, NCN4814Crawford Benjamin D · Anchorage, AKN4814UHash Marshall T · Inglis, FLN4815Ober John A · Candor, NYN4815DBodeen Lance A · Eagle River, AKN4816JMorten Derek J · Northwood, NDN4817DWirt James · Goldsby, OKN4819NSilva Robert · Davis, CAN481CPBlue Water Aviation LLC · Oakman, ALN481DGrey Goose LLC · Wasilla, AKN481HWilliams Stephen C · Georgetown, MEN481JCollins Jason · Mansfield, OHN481PMoody Bible Institute Of Chicago · Spokane Valley, WAN481QAdams Eddie · Senath, MON481TRBowen Tim S · Robstown, TXN481USalter 11x LLC · Duluth, MNN4820SCalico Construction Inc · Kensington, MDN4821USouth Side Corp · Loomis, NEN4822DRegistered aircraftN4822NBalinski Stephen W · Lusby, MDN4824FWheeler Michael P · Declo, IDN4825DHitec Construction Services Inc · Lincoln, CAN4825FLober Richard M · Bishop, CAN4825NBlue 79 LLC · Loogootee, INN4826DTurbine Training Center Inc · Manhattan, KSN4827DWebber David A · Delta Junction, AKN4827UHagen Rainer · Irving, TXN4828DNisbet William T · Driggs, IDN4829NKcj Fly LLC · Fuquay Varina, NCN482CACivil Air Patrol · Maxwell Afb, ALN482CPCivil Air Patrol · Montgomery, ALN482TWT34 Mentor LLC · Saint Joseph, ILN4830NSimansky Daniel W Trustee · Van Nuys, CAN4831DVogel Paul R · Valparaiso, INN4831FWillis Rodney S · Wasilla, AKN4832DM & D Adventures LLC · Ozark, MON4832UBryant David DBA · Athens, TNN4833DSmith Shayne A · Greenville, TXN4833NMegalith LLC · Belvidere, ILN4834DGrismer Larry Trustee · Hemet, CAN4834SBuell Bay Co · Irvington, VA
Back to AD 84-10-01 R1