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.
N42058State Of North Carolina · Raleigh, NCN4205HSwift Leonard M · Goldendale, WAN4205TPoulsen Carlton Jr · Bossier City, LAN42060Satathite Will J · Soldotna, AKN42061Muhle Gerald A · Lincoln, NEN42062Parker Jo K Trustee · Ardmore, OKN42063Bailey Danny R · China Grove, NCN42064Howell Jerry L · Searcy, ARN42067S & M Aviation LLC · Exton, PAN42069Endres Merrick A · Riverview, FLN4206HLeonard James P · Eagle River, AKN4206JRegistration Pending · Linn, MORegistration pendingN4206QOsmonovich Michael · Kent, WAN4206TTownsend Rhett · Manakin Sabot, VAN42072Rempe Richard Henry · Bumpass, VAN42078Hellebuyck Ralph Charles Jr · Attica, MIN4207HGage Duane · Princeton, IDN4207TMisiura Edward Stanley Trustee · Elmhurst, NYN4207YAnderson John A · Palmer, AKN42082Fmp Energy Inc · Bryan, TXN42084Acp Aviation LLC · Oakdale, LAN4208XDeaton Timothy W · Norfork, ARN4208YScout Towing Company · Omaha, NEN42094Mdn LLC · Park City, MTN42095Cpkb · Summit, NJN4209GMhoc LLC · Pensacola, FLN4209HKirby Ronald S · Delta Junction, AKN4209PN4209p LLC · Eagle River, WIN4209QLakeland Aviation Of Minocqua Inc · Minocqua, WIN4209XSimmons Scott E · De Queen, ARN4209ZBy Sky Or By Sea LLC · Kalispell, MTN420BLN420bl LLC · Carmel, INN420CSSugar Lips Aviation LLC · Kalispell, MTN420FMcmullen Morrell E · Angleton, TXN420FPSky Ventures LLC · Flagstaff, AZN420FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN420GBOnemanconcrete LLC · Thaxton, VAN420GNNorsworthy Garry Lynn · Grapeland, TXN420GWSchell Scott A · Lisbon, NDN420HLJannelli Gilbert DBA · Clearwater, FLExpired dealerN420HPBraden Health LLC · Greensboro, NCN420JFlying Mules LLC · Hutchinson, KSN420JHCaptain Hank LLC · Lewes, DEN420LKRegistered aircraftN420LPCross Todd J · Johnstown, CON420RFritz David W · Kerrville, TXN420RMCummiskey Ryan J · Jamesville, NYN420RVHamilton James C · Leesburg, VAN420SBWayne Daryl Hall II · Wasilla, AKN420TVictor James A · Santa Ynez, CA
Back to AD 2007-04-19 R1