AD 99-08-13
Registered aircraft · 640
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:99-08-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:99-08-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:99-08-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:99-08-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.
N745AXCargo Aircraft Management Inc · Wilmington, OHN745CKKalitta Air LLC · Ypsilanti, MIN747GFGe Engine Leasing Holdings Inc · Cincinnati, OHN749AX22226 Inc · Wilmington, DEN750AXBank Of Utah Trustee · Salt Lake City, UTN752AXAeroacq Partners LLC · Laud By Sea, FLN76054United Airlines Inc · Chicago, ILN76055United Airlines Inc · Chicago, ILN76062United Airlines Inc · Chicago, ILN76064United Airlines Inc · Chicago, ILN76065United Airlines Inc · Chicago, ILN760CKKalitta Air LLC · Ypsilanti, MIN761CKKalitta Air LLC · Ypsilanti, MIN761CXCargo Aircraft Management Inc · Wilmington, OHN762CKKalitta Air LLC · Ypsilanti, MIN763CKKalitta Air LLC · Ypsilanti, MIN764CKKalitta Air LLC · Ypsilanti, MIN765CKKalitta Air LLC · Ypsilanti, MIN766CKKalitta Air LLC · Ypsilanti, MIN7672CBank Of Utah Trustee · Salt Lake City, UTN7672DBank Of Utah Trustee · Salt Lake City, UTN767AAramco Associated Co · Houston, TXN767AXCargo Aircraft Management Inc · Wilmington, OHN767CJBank Of Utah Trustee · Salt Lake City, UTN767CKKalitta Air LLC · Ypsilanti, MIN768AXCargo Aircraft Management Inc · Wilmington, OHN77066United Airlines Inc · Chicago, ILN773AXCargo Aircraft Management Inc · Wilmington, OHN774AXCargo Aircraft Management Inc · Wilmington, OHN78060United Airlines Inc · Chicago, ILN781SNAtares Funding LLC · Fisher Island, FLN782CKKalitta Air LLC · Ypsilanti, MIN783AXCargo Aircraft Management Inc · Wilmington, OHN783SNAtares Funding LLC · Fisher Island, FLN787CKKalitta Air LLC · Ypsilanti, MIN793AXAeroacq Partners LLC · Laud By Sea, FLN797AXCargo Aircraft Management Inc · Wilmington, OHN804MSInterface Operations LLC · Las Vegas, NVN804SNAtares Funding LLC · Miami Beach, FLN822NWDelta Air Lines Inc · Atlanta, GAN823NWDelta Air Lines Inc · Atlanta, GAN824NWDelta Air Lines Inc · Atlanta, GAN825MHDelta Air Lines Inc · Atlanta, GAN825NWDelta Air Lines Inc · Atlanta, GAN826MHDelta Air Lines Inc · Atlanta, GAN826NWDelta Air Lines Inc · Atlanta, GAN827MHDelta Air Lines Inc · Atlanta, GAN827NWBank Of Utah Trustee · Salt Lake City, UTN828MHDelta Air Lines Inc · Atlanta, GAN828NWBank Of Utah Trustee · Salt Lake City, UT
Back to AD 99-08-13