AD 2016-25-01
Registered aircraft · 763
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:2016-25-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-25-01')
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:2016-25-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-25-01') 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.
N481CMCargo Aircraft Management Inc · Wilmington, OHN481MCAtlas Air Inc · Purchase, NYN482MCAtlas Air Inc · Purchase, NYN487CMCargo Aircraft Management Inc · Wilmington, OHN489MCAtlas Air Inc · Purchase, NYN491AZCargo Aircraft Management Inc · Wilmington, OHN495MMAmazon.Com Services LLC · Seattle, WAN499AZCargo Aircraft Management Inc · Wilmington, OHN503AZAmazon.Com Services LLC · Seattle, WAN503KWAlta Airlines Holdings LLC · Salt Lake City, UTN503UAUnited Airlines Inc · Chicago, ILN507YVBank Of Utah Trustee · Salt Lake City, UTN508UAUnited Airlines Inc · Chicago, ILN509KWAlta Airlines Holdings LLC · Salt Lake City, UTN518UAUnited Airlines Inc · Chicago, ILN534LAChirihue Leasing Trust · Wilmington, DEN536LAChirihue Leasing Trust · Wilmington, DEN537CAAc Spe 10 LLC · Orlando, FLN538LAQuetro Aircraft Leasing Trust · Wilmington, DEN539USDelta Air Lines Inc · Atlanta, GAN540LACaiquen Leasing LLC · Wilmington, DEN540USDelta Air Lines Inc · Atlanta, GAN541USDelta Air Lines Inc · Atlanta, GAN542LAQuetro Aircraft Leasing Trust · Wilmington, DEN542USDelta Air Lines Inc · Atlanta, GAN543USDelta Air Lines Inc · Atlanta, GAN544USDelta Air Lines Inc · Atlanta, GAN545USDelta Air Lines Inc · Atlanta, GAN547USDelta Air Lines Inc · Atlanta, GAN548USDelta Air Lines Inc · Atlanta, GAN549USDelta Air Lines Inc · Atlanta, GAN550NWDelta Air Lines Inc · Atlanta, GAN551NWDelta Air Lines Inc · Atlanta, GAN552NWDelta Air Lines Inc · Atlanta, GAN553NWDelta Air Lines Inc · Atlanta, GAN554NWDelta Air Lines Inc · Atlanta, GAN555NWDelta Air Lines Inc · Atlanta, GAN556NWDelta Air Lines Inc · Atlanta, GAN557NWDelta Air Lines Inc · Atlanta, GAN564LATagua Owner Trust · Wilmington, DEN566LAJilguero Owner Trust · Wilmington, DEN567CACascade Spares Inc · Knoxville, TNN56859United Airlines Inc · Chicago, ILN568LATagua Owner Trust · Wilmington, DEN569AZAmazon.Com Services LLC · Seattle, WAN569CAAc Spe 11 LLC · Orlando, FLN570LATagua Owner Trust · Wilmington, DEN57111United Airlines Inc · Chicago, ILN571AZAmazon.Com Services LLC · Seattle, WAN572LATagua Owner Trust · Wilmington, DE
Back to AD 2016-25-01