AD 2002-22-12
Registered aircraft · 2,065
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:2002-22-12')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-22-12')
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:2002-22-12') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-22-12') 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.
N180DNDelta 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, TNN18220United Airlines Inc · Chicago, ILN18223United Airlines Inc · Chicago, ILN182ANAersale Inc · Coral Gables, FLN182FEFederal Express Corp · Memphis, TNN182UAUnited Airlines Inc · Chicago, ILN182UWWilmington Trust Co Trustee · Wilmington, DEN183FEFederal Express Corp · Memphis, TNN183HKMarana Aerospace Solutions Inc · Marana, AZN183UWWilmington Trust Co Trustee · Wilmington, DEN184FEFederal Express Corp · Memphis, TNN184GPGpj 184 LLC · Newport Beach, CAN184SKBank 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, GAN187FEFederal Express Corp · Memphis, TNN187USAmerican Airlines Inc · Fort Worth, TXN188DNDelta Air Lines Inc · Atlanta, GAN188FEFederal Express Corp · Memphis, TNN188USAmerican Airlines Inc · Fort Worth, TXN189ANWyatt Aerospace LLC · Chandler, AZN189DNDelta Air Lines Inc · Atlanta, GAN189FEFederal Express Corp · Memphis, TNN189UWAmerican Airlines Inc · Fort Worth, TXN18GBRm Equipment LLC · Seattle, WAN1902STvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN190AAWyatt Aerospace LLC · Chandler, AZN190DNDelta Air Lines Inc · Atlanta, GAN190FEFederal Express Corp · Memphis, TNN190UWAmerican Airlines Inc · Fort Worth, TXN19117United Airlines Inc · Chicago, ILN19130United Airlines Inc · Chicago, ILN19136United Airlines Inc · Chicago, ILN19141United Airlines Inc · Chicago, ILN191ANWyatt Aerospace LLC · Chandler, AZN191DNDelta Air Lines Inc · Atlanta, GAN191FEFederal Express Corp · Memphis, TNN191UWBank Of Utah Trustee · Salt Lake City, UTN192DNDelta Air Lines Inc · Atlanta, GA
Back to AD 2002-22-12