AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N34821Gibbs Keith L · Eaton Rapids, MIN34823Eight Twenty Three LLC · Santa Barbara, CAN34829Woods Roderick D · Collierville, TNN3482THaskell Thomas Edward · Georgetown, TXN3482UMitchell Philip T · Moreland, GAN3482XCollins Dallas · Columbia, SCN34830Airworx LLC · Gotha, FLN34833Dallman Bruce D · Terre Haute, INN34835Saddleback Enterprises LLC · Newport Beach, CAN3483RCentury White Worldwide Inc · Casper, WYN3483SHickey Bill J · La Veta, CON3483TCalhoun Edward J · Whitney, NEN3483UPool Robert Brooks · Lake Charles, LAN3483WSale Reported · Lubbock, TXSale reportedN3483XDoddy Del · Cincinnati, OHN3483YGrimes William H · Seabrook, SCN34845Ccf Ventures Inc · Bangor, MEN34847Hanna David G · Imperial, NEN3484MNiner One Aviation LLC · Hillsboro, ORN3484NPietsch Warren A · Minot, NDN3484RTouch And Go Aviation LLC · Jackson, MNN3484TCairo Jane LLC · Ponca City, OKN3484YSport Obermeyer Ltd · Aspen, CON34850Axs Sourcing It LLC · Chugiak, AKN34852Pride Electric Enterprises · Prescott Valley, AZN34858Schmid Walter Allen · Fruitland, IDFirst renewal noticeN3485LEhalt Christopher J · Lester Prairie, MNN3485SThorp Contractors LLC · Vinita, OKN3485WKemp James A · Deland, FLN3485XCdm Flight Club Inc · La Jolla, CAN3485ZVarco John M · Palmer, AKN34860Pittman Charles R Trustee · Waterloo, ILN34865Schmedeman Andrew J · Sanford, FLN34868Leonard Isaacs Aviation LLC · Fairfield, TXN3486NRose Thomas Z · Santa Ana, CAN3486RMorrissey David H · Queensbury, NYN3486UZhills Pilot LLC · Zephyrhills, FLN3486WSteele Jackie L · London, KYN3486XLaas Enterprises Inc · Warrens, WIN34873Payne Richard L · Flint Hill, VAN34876Clear Sky Flyers LLC · Lincoln, NEN3487QIsrael Jonathan · Huntington Beach, CAN3487SAscent Investments LLC · Kasota, MNN3487ULawser Ron · Townsend, MTN3487XKrzeminski Paul A · San Carlos, CAN34886Brooks Aviation LLC · Wilmington, DEN34888Double J3 Aviation LLC · West Palm Beach, FLN3488NValley Aviation LLC · Fargo, NDN3488SBarbosa Javier · Edinburg, TXN3488WLiberty University School Of Aeronautics · Lynchburg, VA
Back to AD 2007-04-19 R1