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.
N380CCHolmstrom Eric C · Las Vegas, NVN380CDTomlinson Consulting LLC · Columbia, MDN380CVCivil Air Patrol · Maxwell Afb, ALN380DMWiles Shawn Lynn · Lakeland, FLN380ESZak William Roy Jr · Kissimmee, FLN380KCitabria Corporation · Wilmington, DEN380LCLorusso Jason J · Hadley, MAN380MA75 East Air LLC · Valparaiso, INN380MCVeturis David L · Lake Forest, CAN380MEVpc Air Inc · Cartersville, GAN380MFRegistered aircraftN380MMFolk Daniel H · Urbana, ILN380PCRhomberg Bernard B · Elm Grove, WIN380RADarnell Charles Bert · Glen Allan, MSN380RBShea Michael P · Nashua, NHN380UBoard Of Regents Of The University Of Oklahoma · Norman, OKN380WGGuhl Wolfgang · Marietta, GAN381Deal Mark A · Spartanburg, SCN3810CBlake Thomas C · Vero Beach, FLN3810DAdlard Thomas Andrew · Dinuba, CAN3810FTomco Stores Ltd · Ruidoso, NMN3810MSurgical Innovations Inc · Suwanee, GAN3810TN3810t LLC · Kalispell, MTN3810ZFalcon Ridge Industries Inc · Milleville, NJN3811DRegistration Pending · Turner, MTRegistration pending, pending cancellationN3811KHendrickson Raymond G · Severn, MDN3811MBanks Jerry A · Collierville, TNN3811TDeleon Muniz Mario Antonio · Riverside, CAN3811WMartin Gerard A · Boston, KYN3811XBaron 55 LLC · Hanover, NHN3812Kline Brad · Finksburg, MDN38120Hudson Wilburn Joel · Rocky Face, GAN3812CChristiansen Aviation LLC · Wilmington, DEN3812FGreat Lakes Aircraft LLC · Palmer Lake, CON3812TGtm Services LLC · Ames, IAN3812WTuned Up Services Inc · Waldo, FLN3812XJets And Props Corp · Reno, NVN3813FN3813f Inc · Wilmington, DEN3813GOne Three Golf LLC · Cleghorn, IAN3813QBemowski Paul · Madison, WIN3813TCenturion Transportation LLC · Weatherford, OKN3813WTaylor Bruce W · Stroudsburg, PAN3813XRegistered aircraftAssigned, pending cancellationN3813YSheppard David A · Jackson, CAN38146Olson Richard H Trustee · Walla Walla, WAN38147St Denis Robert G · Lake City, FLN3814DReeder Travis · Marana, AZN3814FSnuffer Michael K · Reno, NVN3814PJasinski Jack J · Necedah, WIN3814RCarlton Kevin · Mount Vernon, WA
Back to AD 2007-04-19 R1