AD 2001-08-15
Registered aircraft · 349
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:2001-08-15')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-08-15')
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:2001-08-15') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-08-15') 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.
N410MADodson Parts International Inc · Rantoul, KSN41104United Airlines Inc · Chicago, ILN438MANewcastle Aviation Partners LLC · Fort Myers, FLN43VAAdvanced Air LLC · Statesville, NCN443MANewcastle Aviation Partners LLC · Fort Meyers, FLN48901Delux Public Charter LLC · Dallas, TXN494TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN500DEChampion Air LLC · Mooresville, NCN508RHHms Holdings LLC · Charlotte, NCN509GUTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN509RHHms Holdings LLC · Charlotte, NCN530CNCorporate Flight Management Inc DBA · Smyrna, TNN531CNCorporate Flight Management Inc DBA · Smyrna, TNN532CNCorporate Flight Management Inc DBA · Smyrna, TNN534CNCorporate Flight Management Inc DBA · Smyrna, TNN535CNCorporate Flight Management Inc DBA · Smyrna, TNN538MMenards Inc · Eau Claire, WIN540MMenard Inc · Eau Claire, WIN561JACreamer Pilot Services LLC · Fayetteville, ARN585MMenard Inc · Eau Claire, WIN605KSAmerican Airlines Inc · Fort Worth, TXN608JYD Aircraft Leasing Company LLC · Wilmington, DEN608LMAmerican Airlines Inc · Fort Worth, TXN609DPAmerican Airlines Inc · Fort Worth, TXN610AEAmerican Airlines Inc · Fort Worth, TXN612AEAmerican Airlines Inc · Fort Worth, TXN612EMHome Cloud Aviation LLC · West Palm Beach, FLN613AEAmerican Airlines Inc · Fort Worth, TXN614AEAmerican Airlines Inc · Fort Worth, TXN615AEAmerican Airlines Inc · Fort Worth, TXN616AEAmerican Airlines Inc · Fort Worth, TXN617AEAmerican Airlines Inc · Fort Worth, TXN631AEAmerican Airlines Inc · Fort Worth, TXN632AEAmerican Airlines Inc · Fort Worth, TXN633AEAmerican Airlines Inc · Fort Worth, TXN634AEAmerican Airlines Inc · Fort Worth, TXN635AEAmerican Airlines Inc · Fort Worth, TXN639AEAmerican Airlines Inc · Fort Worth, TXN640AEAmerican Airlines Inc · Fort Worth, TXN641AEAmerican Airlines Inc · Fort Worth, TXN642AEAmerican Airlines Inc · Fort Worth, TXN642TKAviation Trust Company LLC Trustee · Oklahoma City, OKN643AEAmerican Airlines Inc · Fort Worth, TXN644AEAmerican Airlines Inc · Fort Worth, TXN645AEAmerican Airlines Inc · Fort Worth, TXN646AEAmerican Airlines Inc · Fort Worth, TXN647AEAmerican Airlines Inc · Fort Worth, TXN648AEAmerican Airlines Inc · Fort Worth, TXN649PPAmerican Airlines Inc · Fort Worth, TXN650AEAmerican Airlines Inc · Fort Worth, TX
Back to AD 2001-08-15