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.
N111ZMAmerican Airlines Inc · Fort Worth, TXN11206United Airlines Inc · Chicago, ILN112ANAmerican Airlines Inc · Fort Worth, TXN112BJDg Group Aviation LLC · Bloomfield Hills, MIN112BZBank Of Utah Trustee · Salt Lake City, UTN112DNDelta Air Lines Inc · Atlanta, GAN112EDE D Santos & Associates LLC Trustee · Wilmington, DEN112HQRepublic Airways Inc · Carmel, INN112MYAir Force Fun LLC · Woodbury, NYN112QSRegistered aircraftN112USAmerican Airlines Inc · Fort Worth, TXN112VLBank Of Utah Trustee · Salt Lake City, UTN112YVUas Transervices Inc · Boca Raton, FLN113ANAmerican Airlines Inc · Fort Worth, TXN113AXAlaska Central Express Inc · Anchorage, AKN113DXDelta Air Lines Inc · Atlanta, GAN113HQRepublic Airways Inc · Carmel, INN113QSRegistered aircraftN113SRAdams Aviation Services Inc Trustee · Wilmington, DEN114AXAlpine Aviation Inc · Provo, UTN114BZWilmington Trust Co Trustee · Wilmington, DEN114DNDelta Air Lines Inc · Atlanta, GAN114HQRepublic Airways Inc · Carmel, INN114QSRegistered aircraftN114SYSkywest Airlines Inc · St George, UTN114UWAmerican Airlines Inc · Fort Worth, TXN11526Corporate Flight Managment Inc · Smyrna, TNN11535Delux Public Charter LLC · Dallas, TXN11536Bank Of Utah Trustee · Salt Lake City, UTN11539Delux Public Charter LLC · Dallas, TXN11565Corporate Flight Management Inc · Smyrna, TNN115ADAmerican Promotional Events Inc · Florence, ALN115AXAlaska Central Express Inc · Anchorage, AKN115BZWilmington Trust Co Trustee · Wilmington, DEN115DNDelta Air Lines Inc · Atlanta, GAN115HQRepublic Airways Inc · Carmel, INN115JSRegistered aircraftN115LFAirlynner LLC · Jackson, WYN115MHA7p Trust Co Inc Trustee · Cheyenne, WYN115NNAmerican Airlines Inc · Fort Worth, TXN115PKJet Midwest Inc · Kansas City, MON115QSRegistered aircraftN115SEAdvanta Aviation 3500 LLC · La Jolla, CAN115TRTasco LLC · New York, NYN116ADStone Holdings LLC · Towson, MDN116ANUmb Bank Na Trustee · Salt Lake City, UTN116BTUmb Bank Na Trustee · Salt Lake City, UTN116BZWilmington Trust Co Trustee · Wilmington, DEN116DNDelta Air Lines Inc · Atlanta, GAN116HFAirbourne International Inc · Wilmington, DE
Back to AD 2011-01-09