AD 2006-26-13
Registered aircraft · 599
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:2006-26-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:2006-26-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:2006-26-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:2006-26-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.
N683DADelta Air Lines Inc · Atlanta, GAN684DADelta Air Lines Inc · Atlanta, GAN685DADelta Air Lines Inc · Atlanta, GAN686AABank Of Utah Trustee · Salt Lake City, UTN686DADelta Air Lines Inc · Atlanta, GAN687DLDelta Air Lines Inc · Atlanta, GAN688DLDelta Air Lines Inc · Atlanta, GAN688SLAero Micronesia Inc DBA · Barrigada, GUN689DLDelta Air Lines Inc · Atlanta, GAN690DLDelta Air Lines Inc · Atlanta, GAN692AAAersale Inc · Doral, FLN692DLDelta Air Lines Inc · Atlanta, GAN693DLDelta Air Lines Inc · Atlanta, GAN694ANBank Of Utah Trustee · Salt Lake City, UTN694DLDelta Air Lines Inc · Atlanta, GAN695DLDelta Air Lines Inc · Atlanta, GAN696ANBank Of Utah Trustee · Salt Lake City, UTN696DLDelta Air Lines Inc · Atlanta, GAN697ANBank Of Utah Trustee · Salt Lake City, UTN697DLDelta Air Lines Inc · Atlanta, GAN698DLDelta Air Lines Inc · Atlanta, GAN699DLDelta Air Lines Inc · Atlanta, GAN700KWEastern Airlines LLC · Kansas City, MON702CAAc Spe 5 LLC · Orlando, FLN703CKKalitta Air LLC · Ypsilanti, MIN703KWEastern Airlines LLC · Kansas City, MON705KWEastern Airlines LLC · Kansas City, MON705TWDelta Air Lines Inc · Atlanta, GAN706KWEastern Airlines LLC · Kansas City, MON706PCOmega Air Inc · San Antonio, TXN707CAOmega Air Inc · San Antonio, TXN707MQAircraft Endeavors LLC · San Antonio, TXN708AAWorld Aviation Services LLC · Medley, FLN708SSierra Pacific Airlines Inc · Tucson, AZN709SSierra Pacific Airlines Inc · Tucson, AZN711ZXDelta Air Lines Inc · Atlanta, GAN717TWDelta Air Lines Inc · Atlanta, GAN718TWDelta Air Lines Inc · Atlanta, GAN720CKKalitta Charters II LLC · Ypsilanti, MIN721TWDelta Air Lines Inc · Atlanta, GAN722TWDelta Air Lines Inc · Atlanta, GAN723TWDelta Air Lines Inc · Atlanta, GAN724CKKalitta Charters II LLC · Ypsilanti, MIN724TWR&W Flying Inc · Greenbrier, ARN726USUSA Jet Airlines Inc · Belleville, MIN727HLAviation Sales And Charter LLC · Dover, DEN727NKAntares Aviation LLC · Boca Raton, FLN727TWDelta Air Lines Inc · Atlanta, GAN727USUSA Jet Airlines Inc · Belleville, MIN727YKFayaka Airways LLC · San Francisco, CANon-citizen corporation, flight hours not reported
Back to AD 2006-26-13