Skip to content

AD 2006-16-18 R1

Registered aircraft · 11,797

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

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-16-18-R1') 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-16-18-R1') ORDER BY n_number

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-16-18-R1')
    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-16-18-R1')
  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-16-18-R1')
  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-16-18-R1')
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.

N924Y924y LLC · Visalia, CABuilt 1998 · S/N E-3198 N9257QC9 Aero LLC · Gothenburg, NEBuilt 1971 · S/N E-277 N925ANWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N 29526 N925ARRnjs Products LLC · Lewes, DEBuilt 1977 · S/N LJ-725 N925BKAcom Electronic Measurement Technology Inc · Milpitas, CABuilt 1976 · S/N 0117 N925CPoms Scott H · San Mateo, CABuilt 1977 · S/N E-1057 N925DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63535 N925FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0025 N925HJHenderson Jet Services LLC · Georgetown, TXS/N FL-624 N925JATrue North Aviation LLC · Harrisburg, SDBuilt 2017 · S/N 525-0963 N925KNN34lt LLC · Millsboro, DEFirst renewal noticeBuilt 2007 · S/N FL-565 N925MPApegasus LLC · Shelbyville, INBuilt 2000 · S/N 258457 N925NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31169 N925SLInnovative Aviation LLC · Deatsville, ALBuilt 1976 · S/N E-938 N9268QWeyhmuller Luke · Chapin, SCBuilt 1971 · S/N E-279 N926ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29527 N926CBSgj Racing LLC · Miami, FLBuilt 2000 · S/N 650-7114 N926CESilverado Aviation LLC · Fort Wayne, INBuilt 2007 · S/N 560-0763 N926DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63534 N926FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0026 N926MTNew London Aviation LLC · Forest, VABuilt 1978 · S/N 421C0625 N926NCBb & Ryder LLC · Greenbrier, ARBuilt 1995 · S/N 560-0328 N926NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 33321 N926TJBlackhawk Consulting LLC · Raceland, LABuilt 1999 · S/N BB-1662 N9273QFrost Scott · West Palm Beach, FLBuilt 1971 · S/N E-280 N927ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30077 N927AWLambert Contracting LLC · Hollywood, ALBuilt 2001 · S/N E3426 N927DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 64888 N927FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0027 N927JTPikes Peak Flyers Llp · Colorado Springs, COBuilt 1991 · S/N LJ1263 N927NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 31171 N927PKSymmetry Aviation LLC · Mount Pleasant, TXBuilt 2001 · S/N 560-0551 N9286QDunn Louis · Hampshire, ILBuilt 1971 · S/N E-291 N9288QKarle John F · Long Beach, CABuilt 1971 · S/N E-288 N928ALHogsback Holdings LLC · Klamath Falls, ORBuilt 1982 · S/N 041 N928ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 29528 N928DUBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63537 N928FEFederal Express Corporation · Memphis, TNBuilt 1987 · S/N 208B0028 N928HBRegistration Pending · New Brunswick, NJRegistration pendingS/N TH-172 N928JAWorld Champion Air LLC · Acworth, GABuilt 1995 · S/N 0075 N928KAction Offshore LLC · Port Arthur, TXBuilt 1998 · S/N BB-1608 N928KLKa-B200 LLC · San Angelo, TXBuilt 1994 · S/N BB-1482 N928KWAlta Airlines Holdings LLC · Salt Lake City, UTS/N 47928 N928NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 31172 N928PSPegasus II LLC · Nashville, TNS/N 650-0116 N9295Bank Of Utah Trustee · Salt Lake City, UTBuilt 1977 · S/N 532 N929ANAmerican Airlines Inc · Fort Worth, TXBuilt 2000 · S/N 30078 N929BWSkyway K LLC · Middletown, DEBuilt 1998 · S/N BB-1630 N929D929 Delta LLC · Dublin, VABuilt 1985 · S/N TH-1453 N929DZBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 63538

Back to AD 2006-16-18 R1