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.
N538EREmbry-Riddle Aeronautical University Inc · Prescott, AZN538HFSun Aircraft Management LLC · Ormond Beach, FLN538KSKent State University · Stow, OHN538LJessup Ervin L · Cape Girardeau, MOFirst renewal noticeN538LLEl Destino LLC · Center Harbor, NHN538MRArinder Jeffrey A · Peachtree City, GAN538NPolk Equipment Inc · Leesburg, INN538NDAerosim Academy Inc · Sanford, FLN538PCFontaine Scott M · Salt Lake City, UTN538PGSundstrom Steven L · Friendswood, TXN538SCSpartan Education LLC · Tulsa, OKN538SPRc Flying Partners LLC · Fair Oaks, CAN538TCarrasco Mario G · Glendora, CAN53900Nielsen Jeffrey A · Frankfort, MIN53901Aero Flight Dynamics LLC · Riverside, CAN53903Campbell Kasey W · Thornburg, VAN53904Sundblad Ryan M · Albert City, IAN53905Registered aircraftN53906Mock George M · Jackson, GAN53907Sakalaskas Jason · Fairbanks, AKN53909Rawlings Cecile Cole · Palatine, ILN5390E402wd Holdings LLC · Robstown, TXN5390LKnight Ronald J · Mesa, AZN5390NLarsen Steve J · Colton, ORN5390PHankins Jon A · Fort Mohave, AZN5390VSpringfield Flying Service LLC · Columbia, CAN53912Rider R.P. Field · New Gloucester, MEN53914Kauzlarich Steve F · Oakland, CAN53919Alexander Aviation LLC · Brighton, CON5391ASingh Amandeep · Stockton, CAN5391DPope James D · Lewiston, IDN5391EGosser James A · Nicholasville, KYN5391HHansen Alvin Kent · Winamac, INN5391LMarchant Kenneth L · Indianola, OKN5391PWilliams Keith A · Pahrump, NVN53920Aero Dragger Ltd · Warminster, PAN53922Medford Pat G · Phoenix, AZN5392KStill Jonathan L · Carlisle, PAN5392LYablon Brian M · Portland, ORN5392SBrickhouse Charles F · Wake Forest, NCN5392WCorbin Thomas D · Higley, AZN5392YJensen Jeff · Eagle River, AKN5393NRegistration Pending · Craig, CORegistration pendingN5393SSimpson Randall G · Norwalk, IAN5393TTinseth Lance D Trustee · Highlands Ranch, CON5393WGrit Enterprises Inc · Tulsa, OKN5394ABuechler Ronald Dwight · Menifee, CAN5394DBruce Gregory L · Yelm, WAN5394ERusak Robert J · Paris, TXN5394FLo Chris · Mesa, AZ
Back to AD 2007-04-19 R1