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.
N30040Schaller Neil J · New Athens, ILN30043Singer Mark D · Stafford, VAN30044Air Data Solutions LLC · Natchitoches, LAN3004FN3004f LLC · Cranberry Township, PAN3004XNovember Alpha LLC · Dover, DEN3004ZNantz William G · Raleigh, NCN3005CFodor Vincent A · Doylestown, OHN3005DAirline Transport Professionals Corp Of USA · Wilmington, DEN3005FE & E Jones Farms LLC · Munford, ALN3005KEast Valley Flyers LLC · Chandler, AZN3005TSkala Frank M · Wurtsboro, NYN3005ZStamp Christopher L · Rock Stream, NYN30063King Air Inc · Naknek, AKN30064Avarix Inc · Cool, CAN30067Limbacher John P II · Cookeville, TNN30069Sky Pilot Aviation Corp · Carlsbad, CAN3006DWarmkesserl James R · Felton, CAN3006KPrescott Flying Club Inc · South Saint Paul, MNN3006QHarrington Michael L · Twin Falls, IDN3006WJimenez Carlos · Davie, FLN3006YWissner Martin L · Carpenter, WYN30074Dunwoody James Robert · Huntsville, ALN30075Prop & Paddle Aviation LLC · Brainerd, MNN3007BStanly Business Consultants LLC · Albemarie, NCN3007FTroelstra Frederick D · Queensbury, NYN3007KC & B Partnership · Grand Junction, COFirst renewal noticeN3007THorizon Air Ventures LLC · Fincastle, VAN3007WLima Mike Inc · Ham Lake, MNN3008AMackenzie David Webb · Wilmington, DEN3008BSedberry Jason A DBA · Kokomo, INN3008CTech Aero Avionics LLC · Denton, TXN3008EShore Gerald E · Inez, TXN3008FShepherd Michael D · Rock Hill, SCN3008UNaperville Flying Club Inc · Woodridge, ILN3008YWidmier Kolby J · Price, UTN30096Sirek David G · Fritch, TXN30098Humbert Randy M · Tumtum, WAN3009UEdgar Holly A · Tigard, ORN300ABDelaware Aircraft Trust LLC Trustee · New Castle, DEN300ADSlatter Lowell J · Buhl, IDN300AKAmerican Champion Aircraft Corp · Rochester, WIN300ASRandall David C · Hermitage, PAN300BMohave Maverick Aviation LLC · Bullhead City, AZN300BDAircraft Inc · White Bear Lake, MNN300BHGreen Valley Corporation I · San Jose, CAN300BKManning Ryan E · Watsonville, CAN300BLLaroche Christopher J · Bellaire, OHN300BPOpie Aviation Services LLC · Nashville, NCN300BSWarkenton Christopher · Bend, ORN300BWWatson Brent J · Bountiful, UT
Back to AD 2007-04-19 R1