AD 2011-01-09
Registered aircraft · 9,490
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:2011-01-09')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-01-09')
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:2011-01-09') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-01-09') 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.
N104NNUmb Bank Na Trustee · Salt Lake City, UTN104QSRegistered aircraftN104UWUmb Bank Na Trustee · Salt Lake City, UTN105DXUmb Bank Na Trustee · Salt Lake City, UTN105EV2nd Amendment Wholesale Inc · Grand Forks, NDN105FEFederal Express Corp · Memphis, TNN105HQRepublic Airways Inc · Carmel, INN105NNUmb Bank Na Trustee · Salt Lake City, UTN105UWUmb Bank Na Trustee · Salt Lake City, UTN106DNUmb Bank Na Trustee · Salt Lake City, UTN106ECAurogold Aviation Inc Trustee · Wilmington, DEN106HQRepublic Airways Inc · Carmel, INN106KHExecutive Air Solutions Corp · Fort Lauderdale, FLN106NNUmb Bank Na Trustee · Salt Lake City, UTN106SYSkywest Airlines Inc · St George, UTN1073PTvpx Ars Inc Trustee · North Salt Lake, UTN107CZPeri Jets Inc · Roanoke, VAN107DNUmb Bank Na Trustee · Salt Lake City, UTN107HQRepublic Airways Inc · Carmel, INN107LTHabari Inc · Rancho Cucamonga, CAN107NNUmb Bank N A Trustee · Salt Lake City, UTN107SBN107sb Shares LLC · Liberal, KSN107SYSkywest Airlines Inc · St George, UTN107USAmerican Airlines Inc · Fort Worth, TXN1088Fmc Corp · Philadelphia, PAN108ADMarquez Padilla Inc · Bonita, CAN108DNDelta Air Lines Inc · Atlanta, GAN108ETCarlisle LLC · Scottsdale, AZN108HQRepublic Airways Inc · Carmel, INN108MPAircraft Propeller Service LLC · Lake Zurich, ILN108NNAmerican Airlines Inc · Fort Worth, TXN108RLShamrock Aero LLC · Liberty, NCN108UWAmerican Airlines Inc · Fort Worth, TXN1098LLasai Aviation II LLC · Manassas, VAN109BGAviation Leasing Group Inc · Wilmington, DEN109DNDelta Air Lines Inc · Atlanta, GAN109HQRepublic Airways Inc · Carmel, INN109NNBank Of Utah Trustee · Salt Lake City, UTN109QSRegistered aircraftN109RCapital Air Sc LLC · Wilmington, DEN109SYSkywest Airlines Inc · St George, UTN109UWAmerican Airlines Inc · Fort Worth, TXN10EHReh Finance Co · Salt Lake City, UTN10HCKba LLC · Dover, DEN10KJKtkj Challenger LLC · Houston, TXN10MMSarma Aviation LLC · Fort Wayne, INN10SERadair LLC · Memphis, TNN10TNPacific Rim Management LLC · Downey, CAN10UNGlobal Air LLC · Nashville, TNN1101AHeritage Aviation Services LLC · Dallas, TX
Back to AD 2011-01-09