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.
N47WTDoucet Lucius J III · Baton Rouge, LAN47WWLake Shore Aircraft Holdings LLC · Wurtsboro, NYN47WZPengilly Sky LLC · Ellicottville, NYN47ZRZira 2x Alw LLC · College Place, WAFirst renewal noticeN48007White Andrew Kyle · San Diego, CAN4800B310 LLC · Auburn, WAN4800HBellings Jerry A · Neshkoro, WIN4800LFlying Aces LLC · Scappoose, ORN4800PFun Country Soaring · Avon Lake, OHN4800QVan Bortel Inc · Victor, NYN4800SWaalewyn Tracy W · Clermont, FLN4800UWest Michigan Flying Club Inc · Norton Shores, MIN4800VRegistered aircraftN4801GFrederick Aero Development Inc · Murrieta, CAN4801LWilliams Fire Apparatus Inc · Ashland, ALN4801NBrentco Aerial Patrol Inc · Canton, OHN4801PMullens James P · Rogers, ARN4801UMoore Douglas R · Sylvania, GAN4802Chambers Ronald E · Fort Collins, CON4802BJilek Ray A · Spearfish, SDN4802DCentral Pennsylvania Soaring Association Inc · Lemont, PAN4802JSwaz Aviation LLC · Mesa, AZN4802LKrishna Vijay · Appleton, WIN4802NCentral Oregon Aviation Partners LLC · Bend, ORN4802TSmith Terry G · Kamuela, HIN4802UBlue Sky Aviation LLC · Sherwood, ORN4802VWilcox Chad R · Muncy Valley, PAFirst renewal noticeN4802ZHoffman James R · Bethel, AKN4803Molek Jon · Warren, OHN4803EC180 Holdings LLC · Austin, TXN4803FNorman Howard A · Freeport, ILN4803GAarow Aircraft Leasing LLC · Mcminnville, ORN4803KBarker Shawn A · St Maries, IDN4803LJc And Co Menswear Inc · Tulsa, OKN4803PKcn Aero Club Inc · Overland Park, KSN4803QBruntz Leslie H · Oxford, NEN4803SEsmailka Harold E · Ruby, AKN4803TValiair Lc Trustee · Casper, WYN4803WRollins Brian D · Smithville, MSN4804Pixel King 01 LLC · Fort Worth, TXN4804AMakely Abraham M · Culpeper, VAN4804EPrestar Inc · Davis, CAN4804JPetges Nicholas A · Saint Louis, MON4804NMueller Scott · Somis, CAN4805GTidewater Flying Club Inc · Newport News, VAN4805KH & M Aviation LLC · Hamilton, OHN4805LPrunty Gregory A · Saint Peter, MNN4805URice Gary B · College Place, WAN4805VBudulas Peter Panagiotis · Laurel, MDN48061Olsen Mark G Trustee · Ketchikan, AK
Back to AD 2007-04-19 R1