AD 99-01-13
Registered aircraft · 847
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-01-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-01-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-01-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-01-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.
N361NWDelta Air Lines Inc · Atlanta, GAN362NBDelta Air Lines Inc · Atlanta, GAN362NWDelta Air Lines Inc · Atlanta, GAN363NBDelta Air Lines Inc · Atlanta, GAN363NWDelta Air Lines Inc · Atlanta, GAN364NBDelta Air Lines Inc · Atlanta, GAN364NWDelta Air Lines Inc · Atlanta, GAN365NBDelta Air Lines Inc · Atlanta, GAN365NWDelta Air Lines Inc · Atlanta, GAN366CSCsds Asset Management LLC · Rllng Hls Est, CAN366NBDelta Air Lines Inc · Atlanta, GAN366NWDelta Air Lines Inc · Atlanta, GAN367NWDelta Air Lines Inc · Atlanta, GAN368NBDelta Air Lines Inc · Atlanta, GAN368NWDelta Air Lines Inc · Atlanta, GAN369NBDelta Air Lines Inc · Atlanta, GAN369NWDelta Air Lines Inc · Atlanta, GAN370NBDelta Air Lines Inc · Atlanta, GAN370NWDelta Air Lines Inc · Atlanta, GAN371NBDelta Air Lines Inc · Atlanta, GAN371NWDelta Air Lines Inc · Atlanta, GAN372NWDelta Air Lines Inc · Atlanta, GAN373NWDelta Air Lines Inc · Atlanta, GAN374NWDelta Air Lines Inc · Atlanta, GAN375NCDelta Air Lines Inc · Atlanta, GAN376NWDelta Air Lines Inc · Atlanta, GAN377NWDelta Air Lines Inc · Atlanta, GAN378NWDelta Air Lines Inc · Atlanta, GAN380ACUmb Bank Na Trustee · Salt Lake City, UTN397ACTvpx Trust Co LLC Trustee · North Salt Lake, UTN398AVAircol 6 Statutory Trust · Wilmington, DEN401AVAircol 8 · Wilmington, DEN401UAUnited Airlines Inc · Chicago, ILN402UAUnited Airlines Inc · Chicago, ILN404UAUnited Airlines Inc · Chicago, ILN406UAUnited Airlines Inc · Chicago, ILN411AEBank Of Utah Trustee · Salt Lake City, UTN411AVAircol 9 · Wilmington, DEN416AVAircol 19 · Wilmington, DEN426AVAircol 10 · Wilmington, DEN426UAUnited Airlines Inc · Chicago, ILN427UAUnited Airlines Inc · Chicago, ILFirst renewal noticeN428UAUnited Airlines Inc · Chicago, ILN429UAUnited Airlines Inc · Chicago, ILN4304Bank Of Utah Trustee · Salt Lake City, UTN430UAUnited Airlines Inc · Chicago, ILN431UAUnited Airlines Inc · Chicago, ILN432UAUnited Airlines Inc · Chicago, ILN433UAUnited Airlines Inc · Chicago, ILN434UAUnited Airlines Inc · Chicago, IL
Back to AD 99-01-13