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.
N572BWBridgewater State University · Bridgewater, MAN572CDWaite Aviation LLC · Xenia, OHN572DHSportsmans Recon LLC · Hartwell, GAN572EEcho Air LLC · Anchorage, AKN572FGDrw Air Partners LLC · Tyler, TXN572FLLermo Corydon · Avon, NCN572GSickles James D · Caledonia, NYN572HCordrey Kenneth R · Delmar, DEN572JAJ.A. Flight Services LLC · Sugar Grove, ILN572KAtp Aircraft 3 LLC · Wilmington, DEN572NDAerosim Academy Inc · Sanford, FLN572PUTrustees Of Purdue University · West Lafayette, INN572RJUniversity Of Michigan Flyers Inc · Ann Arbor, MIN572SPOld Friend Air LLC · Junction City, ORN572TPaterson Eric G · Blacksburg, VAN572TFAir Fleet Holdings LLC · Missoula, MTN57304Koch Bruce R · Goodrich, MIN57305C And D Company LLC · Lake Park, MNN57309Olmedo Segundo L · Missouri City, TXN5730FObrien Joseph · Saint Paul, MNN5730JLindley Field Flying School LLC · Greensboro, NCN5730VBooher Tabitha O · Livingston, TNN5730WKoprivnik Anton J · Painesville, OHN57311Lelm Lyle K · Turtle Lake, NDN5731ASimpson Christopher David · Reno, NVN5731DBamford Gregory R · Pace, FLN5731JPaulick Adam J · Deerfield, WIN5731MZortman Micky P · Mexico, MON5731QSomers James K Trustee · Montgomery, TXN5731VBig Bend Community College · Moses Lakes, WAN5731WLongview Aviation LLC · Newburgh, INN57320Resley Village Aero LLC · Carlton, TXN57322N57322 LLC · Spout Spring, VAN57324Richards Jeremy · Franklin, TNN57325Baker Ken C · Tehachapi, CAN5732DAerospace Center For Excellence Inc · Lakeland, FLN5732EWynn Josh · Bucyrus, OHN5732KAndrus Ralph · Denison, TXN5732QAir Lords Inc · Middletown, DEN5732URabbe-Lee Tyler A · Minden, NEN5732VErps Jason D · Blue Springs, MON57331Jmj Aviation LLC · Kalispell, MTN57335N57335 LLC · Churchville, PAN57336Wolfe Roark · Flagstaff, AZN57338Meyer Jerry W · Conway, ARN5733BRobertson Nate Allen · Aiken, SCN5733FVazquez Vega Jossel · Vega Baja, PRN5733PStrattner Brian J · Chesapeake, VAN5733QBlue Skies Flying Club · Burien, WAN5733UBerkshire Aviation Enterprises LLC · Great Barrington, MA
Back to AD 2007-04-19 R1