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.
N2736PBeard Jared · Fallon, NVN2736QBachich George A · Napa, CAN2736SVmc Development Inc · Sanger, TXN2736TM & N Leasing Co · Marietta, GAN2736WMcnamara Jeffrey E Trustee · Riverside, CAN2736XMehling Michael R · Fairview, MTN2737AKnight Farms Inc · Pasco, WAN2737JClair Brent · Loraine, ILN2737KFanazick Joseph P · Juneau, AKN2737XFly-By Aviation Services LLC · Colorado Springs, CON2738BSonrise Aviation LLC · Portland, INN2738TProtac Aviation LLC · Highland, CAFirst renewal noticeN2738WMead James R · Jonesboro, ARFirst renewal noticeN2739CLge Flying Club Inc · Marietta, GAN2739GSwanson Gordon · Prescott, AZN2739RPerrong Andrew R · Huntingdon Valley, PAN2739TPickering Kevin P · Lakeland, TNN2739WKessler Henry L · San Gabriel, CAN2739XSvoboda Realty Inc · Bucyrus, KSFirst renewal noticeN2739YEnnis Michael J · Eminence, MON273AAHammerschlag Richard S · Kamiah, IDN273BGates Hiram P · Faribault, MNN273BBBrenthel Industries LLC · Helena, MTN273BTN273bt Air LLC · Sweetser, INN273CAN273ca LLC · Tulsa, OKN273CBGause Timothy L · Georgetown, SCN273CCRegenald Michaud Aviation LLC · Willows, CAN273CPCivil Air Patrol · Maxwell Afb, ALN273EBNorth Country Aircraft Holdings LLC · Watertown, NYN273JTros Corp · Wilmington, DEN273JFParrish Aviation Flight Academy LLC · Southlake, TXN273METopel Holdings LLC · Scottsdale, AZN273NDPurdue Aviation LLC · West Lafayette, INN273PSBlack James F · Sister Bay, WIN273QTrident Aircraft Leasing LLC · Easton, MDN273RRJet Set Aircraft Inc · Van Nuys, CAN273SState Of Alaska Department Of Public Safety · Anchorage, AKN273SBAero White LLC · Wheat Ridge, CON273SHSpitzer Helicopter LLC · Woodland Hills, CAN2740AMcdaniel Joseph Stewart II · Henderson, TXN2740RRegistration Pending · Wilmington, DERegistration pendingN2740TKraybill Paul D · Portola Valley, CAN2740WBakewell Keith · Independence, LAN2741HEaa Aviation Foundation Inc · Oshkosh, WIN2741WEdison Robert J · Anchorage, AKN2741YCoelum LLC · Lake Mary, FLN27423Kadrmas Arnold E · Lewiston, IDN2742DLloyd Land Plane III LLC · Brighton, CON2742HWilbert John W III · Plaquemine, LAN2742QKibler James · Indialantic, FL
Back to AD 2007-04-19 R1