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.
N2791GHoutte Edmund Michael DBA · Palmer, AKN2791PMccarthy Air LLC · Palmer, AKN2791TJoyce George E · Franklinville, NCN2791WToothman John · Fairmont, WVN2792FRoshong Loman · Leesville, LAN2792GSpeedstar Aviation LLC · Kalispell, MTN2792JAndresen Leonard W · Anchorage, AKN2792PVan Wagner Aerial Media LLC · Hollywood, FLN2792QPalmer Paul F · Donnelly, IDN2793GMeyer Steven D · Snohomish, WAN2793THaas Mark A · Ridgecrest, CAN2793WSchneider Aerial Inc · Rugby, NDN2793Y3y Leasing LLC · Englewood, CON2794GClark Jeremiah Jacob · Pleasant Plains, ARN2794JRegistration Pending · Anchorage, AKRegistration pendingN2794QVincer Way LLC · Centennial, CON2795FSmith Casey T · Marietta, GAN2795JEndeavour Flight Training Inc · Miami, FLN2796FX-Ray Engineering Corp · Port Orange, FLN2796GDouglas Cattle LLC · Douglas, AZN2796TPozdolski Casey · Los Osos, CAN2796WPennington Jeffrey B · Wrightwood, CAN2797ABlue Line Aviation LLC · Vidalia, GAN2797EPalm Beach Flyers LLC · Boca Raton, FLN2797FWhatley Charles J · Goliad, TXN2797JAlaska Ultimate Safaris LLC · Homer, AKN2797TD'Angelo Brothers Development LLC · Helena, MTN2797WWebb John H Jr · Paulding, OHN2798CStone Aviation LLC · Sacramento, CAN2798EPumpkin Eater LLC · Tavares, FLN2798FGoodall Maurice M II · Omak, WAN2798GBremerton City Flying Club · Poulsbo, WAN2798TPatriot Aviation Logistics LLC · Lewes, DEN2798WSb Enterprise LLC · Marshall, TXN2798XElsner Kelly John · Menahga, MNN2799GMartin Aviation LLC · Scottsboro, ALN2799QZerden David F · Lincoln Park, NJN2799XHess James R · Heathsville, VAN279AGWings Over Texas Holdings LLC · Denton, TXN279CGDelaware State University · Dover, DEN279CMMckenzie Robert A · Downers Grove, ILN279HLInternational Air Services Inc Trustee · Carson City, NVN279JSAnnapolis Aviation LLC · Annapolis, MDN279KMarble Rick W · Hartford, IAN279LAFive Star Marketing Inc · Morrisville, NCN279LGAltius Aviation LLC · Syracuse, NYN279MASd Aviation LLC · Danville, CAN279MGGeorgia Aviation Authority · Eastman, GAN279NDSowela Technical Community College · Lake Charles, LAN279PWMauck Ryan S Trustee · Bend, OR
Back to AD 2007-04-19 R1