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.
N4711DTimmons Colton R · Parker, CON4711EOregon Seaplanes LLC · Canby, ORN4711FCharter Equine Inc · Amarillo, TXN4711JDoucet Joshua A · Cabot, ARN4711KFhk Inc · Verona, PAN4712AProudfoot Ranches Inc · Ione, ORN4712DWerkema Thomas L · Caledonia, MIN4712KMclellan Bruce A Trustee · Bend, ORN4712NTimberline Helicopters Inc · Sandpoint, IDN4712YGoldfarb Alice F · Conway, MAN4713CTron Aviation LLC · Orlando, FLN4713LHutson Richard M · Trenton, SCN47144Reitz Andrew Perry · Pembroke Pines, FLN4714BGeissler Charles H · Stanton, MNN4714CGorman Aviation LLC · Bartlesville, OKN4714DWallace Brian T · Ogden, UTN4714FHastings Stephen J · Palmer, AKN4714KJld Air LLC · North Hampton, NHN4714NOwen John E · Aiken, SCN4714PKropf Jacob · Halsey, ORN4714RAlford William J · Erie, MIN4714VSwanland Robert C · Grants Pass, ORN4714YSoukup Matthew J · Eagle River, AKN4715DPetracca Carmine J · Lewiston, IDN4715FRegistration Pending · Ukiah, CARegistration pendingN4715JClarke Brent H · Neversink, NYN4715KSki Town Aviation Management LLC · Steamboat Springs, CON4715LSmith Bryan E · Mt Juliet, TNN4715WKelley Christopher L · La Quinta, CAN4716BClose Keith · Anchorage, AKN4716DDavenport Reginald · Evans, WAN4716KGlobal Acquisition Ltd · Davenport, IAN4716LLong Steven M · Baton Rouge, LAN4716NHolcombe Aaron L · Jay, OKN4716VFields William F · Hazard, KYN4716XJessup Sheila · Dublin, CAN4717AOppegaard Craig E · Saint Louis Park, MNN4717CCt Aviation LLC · Fort Worth, TXN4717JBrock Aviation Flight School LLC · Douglasville, GAN4718BMartin Nathaniel W Trustee · Wasilla, AKN4718DAviation Of North Florida LLC · Jacksonville, FLN4718FPbar Inc · Joseph, ORN4718KMayes John · Carson City, NVN4718LSnt Aviation LLC · Laurel, MSN4718NL3harris Technologies Flight Capital LLC · Greenville, TXN4719AAvquest Aviation Services LLC · Montgomery, NYN4719FFrederick Joel · Hobe Sound, FLN4719KOneninekilo LLC · West Linn, ORN4719LMinderman David J · Westlake, OHN471AArcher Aircraft LLC · Wilmington, DE
Back to AD 2007-04-19 R1