AD 84-10-01 R1
Registered aircraft · 20,483
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.
N2777GPacheco Randy L · Pacific Grove, CAN2777XKruskie Douglas · Petoskey, MIN2778FHuber George M · Bentonville, ARN2779FSweatt D Wayne · Memphis, TXN277JKcsi Aerial Patrol Inc · Bakersfield, CAN277MTException LLC · Manning, SCN277TCTranslift Inc · Holly, MIN277TMPollock Donald Edward · Union Hall, VAN277USCooper Robert · Sugar Grove, ILN2780GHolden Christa · Rougemont, NCN2780XMontgomery Jeffrey L · Anthem, AZN2781DFejes Guide Service Ltd · Anchorage, AKN2781QGibboney Phillip M · Roseville, CAN2781XN2781x LLC · Kingston, GAN2782FMansoori Ali S · Aurora, CON2782QBauer Aviation LLC · Reese, MIN2783FVspp Consulting LLC · Stevensville, MDN2783GLarue Terrence W · Ellensburg, WAN2784GFlaps Up LLC · Kaysville, UTN2784XGillett Welles III · Horseheads, NYN2785FAugustin Lyn H · Saint Thomas, NDN2785KPontiac Flying LLC · Pontiac, ILN2786FChristoph Nicolas T · Okanogan, WAN2786GAvery John W · Fergus Falls, MNFirst renewal noticeN2786XRegistered aircraftN2787FWammen Gil V · Reva, SDN2787GGomez Bermudex Investments LLC · Lauderhill, FLN2787KWhirlwind Aviation Inc · Fisher, ARN2787QThorell Farms Inc · Loomis, NEN2788FShryock Patrick D · King Salmon, AKN2788GCaldwell Gregg P · Desert Hot Springs, CAN2788QKahle Matthew N · Paw Paw, MIN2789FHouck Joshua B · Wa Ct House, OHN2789QCenterline LLC · Yankton, SDN2790GBryan Roger J · Spearfish, SDN2790QArthur Lloyd T · Greenfield, INN2791GHoutte Edmund Michael DBA · Palmer, AKN2792FRoshong Loman · Leesville, LAN2792GSpeedstar Aviation LLC · Kalispell, MTN2792QPalmer Paul F · Donnelly, IDN2793GMeyer Steven D · Snohomish, WAN2794GClark Jeremiah Jacob · Pleasant Plains, ARN2794QVincer Way LLC · Centennial, CON2795FRegistration Pending · Marietta, GARegistration pendingN2796FX-Ray Engineering Corp · Port Orange, FLN2796GDouglas Cattle LLC · Douglas, AZN2797FWhatley Charles J · Goliad, TXN2798CStone Aviation LLC · Sacramento, CAN2798FGoodall Maurice M II · Omak, WAN2798GBremerton City Flying Club · Poulsbo, WA
Back to AD 84-10-01 R1