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.
N1107MAsifd LLC · Dallas, TXN110ANAmerican Airlines Inc · Fort Worth, TXN110AXAlaska Central Express Inc · Anchorage, AKN110CPPruitt Corp · Leesburg, VAN110DXDelta Air Lines Inc · Atlanta, GAN110GDBank Of Utah Trustee · Salt Lake City, UTN110HQRepublic Airways Inc · Carmel, INN110MWRegistered aircraftN110PKJet Midwest Inc · Kansas City, MON110QSRegistered aircraftN110UWAmerican Airlines Inc · Fort Worth, TXN110WSPack Wikert II LLC · Anchorage, AKN11106United Airlines Inc · Chicago, ILN11107United Airlines Inc · Chicago, ILN11113United Airlines Inc · Chicago, ILN11119United Airlines Inc · Chicago, ILN11121United Airlines Inc · Chicago, ILN11127United Airlines Inc · Chicago, ILN11140United Airlines Inc · Chicago, ILN11150United Airlines Inc · Chicago, ILN11164United Airlines Inc · Chicago, ILN11165United Airlines Inc · Chicago, ILN1116RCtb Inc · Milford, INFirst renewal noticeN11176United Airlines Inc · Chicago, ILN11181United Airlines Inc · Chicago, ILN11184United Airlines Inc · Chicago, ILN11187United Airlines Inc · Chicago, ILN11189United Airlines Inc · Chicago, ILN11191United Airlines Inc · Chicago, ILN11192United Airlines Inc · Chicago, ILN11193United Airlines Inc · Chicago, ILN11194United Airlines Inc · Chicago, ILN11199United Airlines Inc · Chicago, ILN1119KNewer Horizons LLC · Cave Springs, ARN111AXAlaska Central Express Inc · Anchorage, AKN111CCWilmington Trust Co Trustee · Wilmington, DEN111CXMojave Jet LLC · Nolensville, TNN111DCDelta Air Lines Inc · Atlanta, GAN111EDBnp Holdings LLC · Lakewood Ranch, FLN111ELContinuum Aviation LLC · Oklahoma City, OKN111FEFederal Express Corp · Memphis, TNN111FKFk Air LLC · Miami, FLN111FWAcme Management Co · Fort Worth, TXN111HQRepublic Airways Inc · Carmel, INN111MDArgosy Aircraft Inc · Reno, NVN111NHE190 Msn111 LLC · Dover, DEN111QSRegistered aircraftN111RZMetropolitan Telecommunications Corp Of De LLC · Holmdel, NJN111USAmerican Airlines Inc · Fort Worth, TXN111YVUas Transervices Inc · Boca Raton, FL
Back to AD 2011-01-09