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.
N46DHMusgrave John R · Morris, ILN46DJBullough William Ronald · Ocala, FLN46DMEdwards John Guerrant · Stoneville, NCN46DTEagle Ad-Venture LLC · Universal City, TXN46DZLuepke Quinn L · Wasilla, AKN46EAEssential Aviation LLC · Meridianville, ALN46EHStar H Aviation LLC · Plano, TXN46ERAviation Trust Company LLC Trustee · Oklahoma City, OKN46ETNicholson Jim · Cody, WYN46EXRegistered aircraftN46EYFirefly LLC · Del Mar, CAN46FCCopeland Forrest H · Brentwood, CAN46FFFf22 LLC · Scottsdale, AZN46FTSerrino Sam K · Youngstown, OHN46GLawton Richard L · Durango, CON46GACrosswind Leasing LLC · Prescott, AZN46GBBuzel George Jr · Trumbull, CTN46GGSpitzer Helicopter LLC · Wilmington, DEN46HCCammack Howard D · Centennial, CON46HDPrice Jesse · Fargo, NDN46HSBlackburn Aviation Air LLC · Mesa, AZN46HYCelli Consulting LLC · Stockton, CAN46JEHood Matthew G · Argyle, TXN46JFTisdell Michael S · Olivia, MNN46JJWoods Terence R · Ankeny, IAN46JLWeaver Aviation LLC · Yucaipa, CAN46JRRay Homer A · Petrolia, CAN46JTWorldwide Aviation Services LLC · Anderson, SCN46JWWerner John D · Pownal, VTN46KBBoatright Kyle W · Marietta, GAN46KRPeterson Aviation LLC · Texarkana, TXN46LAMagoon Paul J · Merrimack, NHN46LEKepley Aviation LLC · Smyrna, TNN46LULetourneau University · Longview, TXN46MJones Gregory D · Pueblo, CON46MBAig Aeronautics LLC · Guaynabo, PRN46MGHughes Shaun · Everett, WAN46MMHoover Travis F · Mountain View, OKN46MPAnderson Howard E · Luray, VAN46MRDavin Matthew · Ridgecrest, CAN46MUMedic Choppers LLC · Springdale, ARN46PAAyer William S · Bellevue, WAN46PCMace Robert C Jr · Gold Canyon, AZN46PGRegistered aircraftN46PKTensas Taildraggers LLC · Saint Joseph, LAN46PNNuss Paul E Sr · Martinsburg, PAN46RERocks Aero LLC · Carbondale, CON46RKAir Positive LLC · Selbyville, DEN46RRAma Aviation LLC · Dover, PAN46RSHixson Steven D · Longview, WA
Back to AD 2007-04-19 R1