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.
N42335Gubernat John F Jr · Pepperell, MAN4233CFons William M · Oconomowoc, WIN4233QWoods John B · Anchorage, AKN4233TSmith Michael L · Lakeland, FLN4233ZThompson Lee B · Anchorage, AKN42349Skylane 49 LLC · Glenwood Springs, CON4234HKacprzak Dominik · Kingwood, TXN4234JHomerun Horizons LLC · Weatherford, TXN4234QFarr Everett L III · Bensalem, PAN4234TParsons Donald Jr · Crumpler, NCN4234ZLueking Clyde F · Holdrege, NEN42358Bakker Margaret E Trustee · Petaluma, CAN42359Lincoln Roger Trustee · Gildford, MTN4235CColville LLC · Signal Mountain, TNN4235HJunker Gregory G · Cincinnati, OHN4235JBarrett Kevin M · Pittsburg, TXN4235RWustman Charles Dryer · Westerly, RIN42361Lima 001 LLC · Muscatine, IAN42363Harrison Kent B · Grass Valley, CAN42364Smathers Geoffrey R · Mars, PAN42368Madson Chris J · King City, CAN42369Hecker Darin · Grants Pass, ORN4236QTyrrell Jerry R · Woodland, WAN4236ZMinnehan Joseph T · Joplin, MTN42371Optum Sun LLC · Laguna Hills, CAN42376Johnson Lytle D · Anacortes, WAN42379Wh Land Holdings LLC · Kirbyville, TXN4237CBreakaway Group Aviation LLC · Franklin, TNN4237JMoppert Stephen Kyler · Madison, MSN4237TPeak 2 Peak Enterprises LLC · Sebring, FLN4237XSpitzer Helicopter LLC · Woodland Hills, CAN4237ZYorgason Ty C · Worland, WYN42380Payne Patricia C · Spokane, WAN42381Anthony David W · Wasilla, AKFirst renewal noticeN42382Nb Services LLC · Sumrall, MSN42387Bernau Jeff A · Kalispell, MTN42388Mccaan Jerome · Bethel, MEN4238CSouthern Aircraft Consultancy Inc Trustee · Casper, WYN4238FAviation Trust Company LLC · Oklahoma City, OKN4238HChandler Michael Shane · Texarkana, TXN4238QFisch Markus J · Rock Falls, ILN4238TChopper Aviation LLC · Cahokia Heights, ILN42396Lawrence Jack C Jr · Saint Augustine, FLN42397Brissey Forrest L · Woodinville, WAN4239HGray Steven Don · Tualatin, ORN4239POneal Hollis R · Deridder, LAN4239QElizabeth City State University · Elizabeth City, NCN4239WSmith James W · Newtown, CTN4239ZLsk Aviation Corp · Wilmington, DEN423ATWillcutt Air Tax LLC · Vicksburg, MI
Back to AD 2007-04-19 R1