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.
N307BTKukowski Matthew P · Wheatland, WYN307BZSummit Aviation Inc · Belgrade, MTN307CEmbedded Advantage LLC · Chelsea, MIN307CDBarton Michael · Creve Coeur, MON307CFSchwarzenberg Johannes · Helena, MTFirst renewal noticeN307DPZuber Thomas P · Opelika, ALN307EZWilliams Guy W · Tehachapi, CAN307FCanadian Flyer LLC · Las Vegas, NVN307GHollister Jet Center Inc · Hollister, CAN307GRJ & D Flying LLC · Sand Point, AKN307HPButler Tracey D · Buckley, WAN307JHRoundy Joseph · Three Forks, MTN307JSPittard Kirk L · Grapevine, TXN307KKSharp Gary · Rigby, IDN307MJSheridan Pilots 307 LLC · Sheridan, WYN307NDUniversity Of North Dakota · Grand Forks, NDN307POetting William · Midland, ORN307PMRegistered aircraftN307PTWindmeier David W · Wheatland, WYN307RT-Tailers LLC · Kalispell, MTN307RBHawaii Pacific Aviation Inc · Kailua Kona, HIN307SHParker Helicopters Inc · Watsonville, CAN307SPSheridan Pilots 307 LLC · Sheridan, WYN307TTCharter Place LLC · Jackson, WYN307ZEsterak David R · Boyce, LAN30800Congdon Carl J · Manley Hot Springs, AKN30803Vampire Aviation LLC · Wilmington, DEN30805Joshua Apodaca · Glendale, AZN30807Edwards Garland U · Midlothian, VAN30809Brooks Sondra · Callicoon, NYN3080BLamermayer Amy E · Fairfield, OHN3080ESky Safety Inc · San Antonio, TXN3080KSnuggs Ronald S · Driggs, IDN3080QN3080q LLC · Phoenix, AZN3080YHd Aviation LLC · Birch Tree, MON3080ZEriksson Kurt R · Soldotna, AKN30813T L Irrigation · Hastings, NEN30819Collins William T · Cameron, TXN3081EWilliams Gregory B · Verona, WIN3081FHenion John D · Trumansburg, NYN3081PVan Zant Robert E · Salem, WIN3081TAviation Training Inc · Cameron Park, CAN30822Hogancamp John M · Lebanon, TNN30823Indian Hills Community College · Ottumwa, IAN30824Rude Allen · Mcville, NDN30826Grundy James W · W Greenwich, RIN30828Lary Leanne K · Thousand Oaks, CAN3082CJets To Helis LLC DBA · Chandler, AZN3082EAirgo Inc · Centralia, ILFirst renewal noticeN3082GSmith Dennis W · Oshkosh, WI
Back to AD 2007-04-19 R1