AD 2011-12-01
Registered aircraft · 4,702
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-12-01')
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-12-01')
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-12-01') 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-12-01') 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.
N175DZDelta Air Lines Inc · Atlanta, GAN175FEFederal Express Corp · Memphis, TNN175JMKc Aviation Partners LLC · Wilmington, DEN176DZDelta Air Lines Inc · Atlanta, GAN176FEFederal Express Corp · Memphis, TNN176UWAmerican Airlines Inc · Fort Worth, TXN17719United Airlines Inc · Chicago, ILN17730United Airlines Inc · Chicago, ILN177DNDelta Air Lines Inc · Atlanta, GAN177DZDelta Air Lines Inc · Atlanta, GAN177FEFederal Express Corp · Memphis, TNN177USAmerican Airlines Inc · Fort Worth, TXN177XFWilmington Trust Co Trustee · Wilmington, DEN178DNDelta Air Lines Inc · Atlanta, GAN178DZDelta Air Lines Inc · Atlanta, GAN178FEFederal Express Corp · Memphis, TNN178USAmerican Airlines Inc · Fort Worth, TXN1796Somer Charles Michael · Hillsboro, ORN179DNDelta Air Lines Inc · Atlanta, GAN179FEFederal Express Corp · Memphis, TNN179JMKc Aviation Partners LLC · Wilmington, DEN179UWWilmington Trust Co Trustee · Wilmington, DEN17TFComanche Warbirds Inc · Houston, TXN1805ABank Of Utah Trustee · Salt Lake City, UTN180DNDelta Air Lines Inc · Atlanta, GAN180FEFederal Express Corp · Memphis, TNN180USWilmington Trust Co Trustee · Wilmington, DEN18112United Airlines Inc · Chicago, ILN18119United Airlines Inc · Chicago, ILN181FEFederal Express Corp · Memphis, TNN181UWAmerican Airlines Inc · Fort Worth, TXN18220United Airlines Inc · Chicago, ILN18223United Airlines Inc · Chicago, ILN18243United Airlines Inc · Chicago, ILN182ANAersale Inc · Coral Gables, FLN182FEFederal Express Corp · Memphis, TNN182UAUnited Airlines Inc · Chicago, ILN182UWWilmington Trust Co Trustee · Wilmington, DEN183FEFederal Express Corp · Memphis, TNN183UWWilmington Trust Co Trustee · Wilmington, DEN184FEFederal Express Corp · Memphis, TNN184SKBank Of Utah Trustee · Salt Lake City, UTN184USAmerican Airlines Inc · Fort Worth, TXN185DNDelta Air Lines Inc · Atlanta, GAN185FEFederal Express Corp · Memphis, TNN185UWAmerican Airlines Inc · Fort Worth, TXN186DNDelta Air Lines Inc · Atlanta, GAN186FEFederal Express Corp · Memphis, TNN186USAmerican Airlines Inc · Fort Worth, TXN187DNDelta Air Lines Inc · Atlanta, GA
Back to AD 2011-12-01