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.
N3391EOcala Aviation Services Inc · Ocala, FLN3391FKingston Terry D · Irving, TXN3391RValiair Lc Trustee · Casper, WYN3391TCardinal Wings LLC · Middletown, DEN3391WNeckerauer John R · Acme, PAN3391XDunham Seth Aaron · Acampo, CAN3391ZThompson Michael M · Soldotna, AKN3392DHaszard John R · Ophelia, VAN3392REllsworth Steven C · Muscatine, IAN3392WMartinez Paul · Sonora, TXN3393RBay Richard G · Sparks, NVN3393TWilcox Russell J · Salinas, CAN3393XJohnson Terence A · Caldwell, IDN3393ZWilliams Shane · Union, ORN3394DCartledge Charles J · Orrville, OHN3394RCurren Patrick V · Green Bay, WIN3394TPekrul Eric C · Frankfort, MIN3394YNolt Ivan M · Mount Solon, VAN3394ZNord Margie N Trustee · Cantwell, AKN3395DFitzgerald John A Jr · Ester, AKN3395RJohnston Osceola Holdings LLC · Dallas Center, IAN3395WGabrick Steven J · Hickory Valley, TNN3395YTriple J Aviation · East Quogue, NYN3396FThompson Patrick J · Evanston, WYN3396QRomanair Wdr Inc · Winder, GAN3396RSimmons Craig · Houston, TXN3396WDaubert Donald W · Chandler, AZN3396XS R Gilliam Construction Inc · Carthage, NCN3396YPlane Fun Inc · Lewes, DEN3396ZPineland Holdings LLC · Gibsland, LAN3397FKerns Aaron R · Sullivan, INN3397GPro Aire Cargo & Consulting Inc · Oshkosh, WIN3397RKcsi Aerial Patrol Inc · Bakersfield, CAN3397SMcrae Richard · Kent, WAN3397TMckinney Adrian R · Mineral Wells, TXN3397WLarson Robb J · Danbury, WIN3398R3y3 Piper Group LLC · Saint Charles, IAN3398XWinkers John W Jr · Woodstown, NJN3398YBobbitt Michael · Lamont, OKN3399FVetter T Kevin Trustee · Phoenix, AZN3399LMetz William · Laurel, MTN3399QBaron Aviation Corporation · Broad Run, VAN3399RGleason Joseph P · Knoxville, TNN3399UWorley Dan J · Perris, CAN3399ZAsquith-Heinz Quinn · Juneau, AKN339AMills Scott I · Littleton, CON339AGGirard Albert J · Portsmouth, RIN339ASMarkone Health LLC · Shelby, NCN339BGBowling Green Flight Center LLC · Bowling Green, OHN339CSmith Cole · Parrish, FL
Back to AD 2007-04-19 R1