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.
N3455YKimmel James W · Fountain Hills, AZN34566Inspiring Flight · Scottsdale, AZN34568Diebel Darrel L · Okanogan, WAN3456BSale Reported · Viroqua, WISale reportedN3456MBuxton Michael · Grand Junction, CON3456PBels Holdings LLC · Albert Lea, MNN3456QL & J Aviation Inc · Atwater, CAN3456UWright James R · Georgetown, CAN3456YGold Michael Benjamin · Frazier Park, CAN34577Registration Pending · Page, AZRegistration pendingN34579Oliver Terry L · Polk City, FLN3457BChase Dennis A · Naperville, ILN3457ETri Star Aviation & Development Ltd · Bath, NCN3457FStreet Jim A · Pilot Point, TXN3457PSewade Dawn M · New River, AZN3457SC Ville Flying Club · Nunica, MIN3457USelway Aviation Inc · Missoula, MTN3457WBas Part Sales LLC · Greeley, CON3457ZHanus Phillip J · Ashley, MIN3458Johnston Donald Trustee · Pickford, MIN34580Contois Richard R · Renton, WAN3458FAirport Lounge Mbi LLC · Dayton, OHN3458GAmerican Aircraft Sales LLC · Livermore, CAFirst renewal noticeN3458QIngram John · Los Angeles, CAN3458TBrown Lance D · Cottonwood, CAN3458WBerquist Glenn A · Columbus, MSN3458XDalton Robert E · San Martin, CAN3458YDelahunt David M · Simi Valley, CAN34592Van Cleve Cole · Cotulla, TXN34594Paschall David C · Hernando, MSN34597G2 Aviation LLC · Wheatland, WYN3459KCarrell David W · Pittsburgh, PAN3459NHageman Robert · Austin, TXN3459Q51st Aero Squadron LLC · Hoover, ALN3459RRtd Aviation LLC · Hillsborough, NJN3459SStg LLC · Mountain Green, UTN3459UWalker Cody · Jacksboro, TXN3459WPannell Lucas J · Midland City, ALN3459YPepper William G · Fayette, MEN345AMantiply Paul · Columbia, CAN345AEChannel City Flyers Inc · Santa Barbara, CAFirst renewal noticeN345AGSkywest Leasing Inc · St George, UTN345ALItm Aircraft LLC · Charleston, SCN345AROhio University · Albany, OHN345ASDwyer Aaron B · San Jose, CAN345BPeraton Services LLC · Venice, CAN345BBBaas Brian J Trustee · Cambridge, MNN345BCScalera Dominic P · West Boylston, MAN345BJPerformance Aero LLC · Diamondhead, MSN345BKMckenzie Michael C · Ventura, CA
Back to AD 2007-04-19 R1