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.
N35219Nelson Laurel L · Renton, WAN3521KState Of North Carolina · Raleigh, NCN3521MNationwide Aviation LLC · Hudson Oaks, TXN3521PJet Jam LLC · Layton, UTN3521QCub Club Inc · Fort Myers, FLN3521YSportsman Airpark Inc · Newberg, ORN3522Barnett Charles J · St Peter JerseyN35220Spoor John B Jr · Sandwich, ILN35225Nguyen Ricky L · Honolulu, HIN35229Coneburripul Corp · Miami, FLN3522EKilgore William B · Eureka, CAN3522KAsap Realty LLC · Stroud, OKN3522NRegistration Pending · Mandeville, LARegistration pendingN3522PBurling Daniel J DBA · Warsaw, NYN3522QRamirez Jose Marcos · Casa Grande, AZN3522UDfs · Bountiful, UTN3522YBohlen Thomas R · Hudson, WIN35230Christiansen Aviation LLC · Wilmington, DEN35238Williams E E · Atlanta, GAN3523MMichigan Seaplane LLC · White Lake, MIN3523PAdair Lawrence L Jr · Fountain Run, KYN3523QRed Crest Aviation LLC · Columbus, OHN3523RAviator Air Flight School LLC · Grand Prairie, TXN3523UCharlson Aaron H Jr · Forest City, IAN3523WRamunni Andrew R · Medina, OHN35242Dlss Inc · Caro, MIN35244Richardson Barry T · Butler, TNN35246N35246 LLC · Stuart, FLN35247Dwyer John R · Orange Park, FLN35249Baker Douglas · Rye, NHN3524FRegistered aircraftN3524LFlight Training Aircraft LLC · Wilmington, DEN3524NRickard Donald S · Florence, ALN3524PRichard Waldren LLC · Newberg, ORN3524QRegistered aircraftN3524UHudson George R · Hueytown, ALN3524WDiaz Albert · Ocean Springs, MSN3524XKendrick Brian S · Kerrville, TXN3524ZRehmel Robert S · Liberty, INN35253Liu Kaiyu · Metairie, LAN35259Gately Brian P · Brooklyn, NYN3525FR&R Aviation · Gunnison, CON3525URandolph Macon Academy · Front Royal, VAN3525WDavis Micihael K · Madison, GAN3525ZCollier Ronald O Trustee · Seymour, TNN35262Aerial Photos Of New Jersey LLC · Clinton, NJN35264B&L Aviation LLC · Villa Rica, GAN3526ARoeder Miles · Houston, TXN3526FHaskett Steven E · Austin, TXN3526KCooke Canyon C · Marana, AZ
Back to AD 2007-04-19 R1