AD 2000-15-01
Registered aircraft · 901
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:2000-15-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:2000-15-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:2000-15-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:2000-15-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.
N325NVSunrise Asset Management LLC · Las Vegas, NVN325USDelta Air Lines Inc · Atlanta, GAN326NBDelta Air Lines Inc · Atlanta, GAN326NVSunrise Asset Management LLC · Las Vegas, NVN327JTRegistered aircraftN327NBDelta Air Lines Inc · Atlanta, GAN327NVSunrise Asset Management LLC · Las Vegas, NVN328NBDelta Air Lines Inc · Atlanta, GAN328NVSunrise Asset Management LLC · Las Vegas, NVN328NWDelta Air Lines Inc · Atlanta, GAN329NBDelta Air Lines Inc · Atlanta, GAN329NWDelta Air Lines Inc · Atlanta, GAN330DXBank Of Utah Trustee · Salt Lake City, UTN330NBDelta Air Lines Inc · Atlanta, GAN330NVSunrise Asset Management LLC · Las Vegas, NVN331DNBank Of Utah Trustee · Salt Lake City, UTN33203United Airlines Inc · Chicago, ILN33209United Airlines Inc · Chicago, ILN33262United Airlines Inc · Chicago, ILN33264United Airlines Inc · Chicago, ILN33266United Airlines Inc · Chicago, ILN33284Umb Bank Na Trustee · Salt Lake City, UTN33286United Airlines Inc · Chicago, ILN33289United Airlines Inc · Chicago, ILN33294Wells Fargo Trust Co Na Trustee · Columbia, MDN332DNBank Of Utah Trustee · Salt Lake City, UTN332NBDelta Air Lines Inc · Atlanta, GAN333NBDelta Air Lines Inc · Atlanta, GAN333NWDelta Air Lines Inc · Atlanta, GAN334NBDelta Air Lines Inc · Atlanta, GAN334NVSunrise Asset Management LLC · Las Vegas, NVN334NWDelta Air Lines Inc · Atlanta, GAN335CKKalitta Charters II LLC · Ypsilanti, MIN335DNBank Of Utah Trustee · Salt Lake City, UTN335NBDelta Air Lines Inc · Atlanta, GAN335NVSunrise Asset Management LLC · Las Vegas, NVN335NWDelta Air Lines Inc · Atlanta, GAN336CKKalitta Charters II LLC · Ypsilanti, MIN336DXBank Of Utah Trustee · Salt Lake City, UTN336NBDelta Air Lines Inc · Atlanta, GAN336NWDelta Air Lines Inc · Atlanta, GAN33714United Airlines Inc · Chicago, ILN337DNUmb Bank Na Trustee · Salt Lake City, UTN337NBDelta Air Lines Inc · Atlanta, GAN337NVSunrise Asset Management LLC · Las Vegas, NVN338DNUmb Bank Na Trustee · Salt Lake City, UTN338NBDelta Air Lines Inc · Atlanta, GAN338NWDelta Air Lines Inc · Atlanta, GAN339NBDelta Air Lines Inc · Atlanta, GAN339NWDelta Air Lines Inc · Atlanta, GA
Back to AD 2000-15-01