AD 2007-19-13
Registered aircraft · 2,446
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:2007-19-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-19-13')
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:2007-19-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-19-13') 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.
N487CMCargo Aircraft Management Inc · Wilmington, OHN487UAUnited Airlines Inc · Chicago, ILN488UAUnited Airlines Inc · Chicago, ILN489MCAtlas Air Inc · Purchase, NYN489UAUnited Airlines Inc · Chicago, ILN4901UUnited Airlines Inc · Chicago, ILN490UAUnited Airlines Inc · Chicago, ILN491AZCargo Aircraft Management Inc · Wilmington, OHN491UAUnited Airlines Inc · Chicago, ILN492UAUnited Airlines Inc · Chicago, ILN493UAUnited Airlines Inc · Chicago, ILN494UAUnited Airlines Inc · Chicago, ILN495UAUnited Airlines Inc · Chicago, ILN496UAUnited Airlines Inc · Chicago, ILN497UAUnited Airlines Inc · Chicago, ILN498UAUnited Airlines Inc · Chicago, ILN499AZCargo Aircraft Management Inc · Wilmington, OHN503AZAmazon.Com Services LLC · Seattle, WAN503JBJetblue Airways Corp · Longisland City, NYN503KWAlta Airlines Holdings LLC · Salt Lake City, UTN504JBJetblue Airways Corp · Long Island City, NYN505JBJetblue Airways Corp · Long Island City, NYN505VLWells Fargo Trust Co Na Trustee · Columbia, MDN506ASUmb Bank Na Trustee · Salt Lake City, UTN506JBJetblue Airways Corp · Long Island City, NYN506VLBank Of Utah Trustee · Salt Lake City, UTN507AYAmerican Airlines Inc · Fort Worth, TXN507JTJetblue Airways Corp · Long Island City, NYN507VLUmb Bank Na Trustee · Salt Lake City, UTN508ASAlaska Airlines Inc · Seattle, WAN508AYAmerican Airlines Inc · Fort Worth, TXN508BCAlta 777 LLC · Salt Lake City, UTN508JLJetblue Airways Corp · Long Island City, NYN508VLBank Of Utah Trustee · Salt Lake City, UTN509AYAmerican Airlines Inc · Fort Worth, TXN509BCJet Midwest Inc · Kansas City, MON509JBJetblue Airways Corporation · Long Island City, NYN509KWAlta Airlines Holdings LLC · Salt Lake City, UTN509VLWells Fargo Trust Co Na Trustee · Columbia, MDN510JBJetblue Airways Corp · Long Island City, NYN510UWAmerican Airlines Inc · Fort Worth, TXN510VLUmb Bank Na Trustee · Salt Lake City, UTN511VLWilmington Trust Co Trustee · Wilmington, DEN512ASWilmington Trust Co Trustee · Wilmington, DEN512JNAtares Funding LLC · Fisher Island, FLN512VLWells Fargo Trust Co Na Trustee · Columbia, MDN513ASUmb Bank Na Trustee · Salt Lake City, UTN513SNM48513 LLC · Esters, FLN513VLWells Fargo Trust Co Na Trustee · Columbia, MDN514ASAlaska Airlines Inc · Seattle, WA
Back to AD 2007-19-13