Skip to content

AD 2006-16-18 R1

Registered aircraft · 11,798

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.

N855BBAmador Stage Lines Inc · Sacramento, CABuilt 2000 · S/N 525-0381 N855DCCunningham Mark · Paris, TXS/N E-3585 N855DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 31966 N855EDSky Miles LLC · Sioux Falls, SDBuilt 2014 · S/N 525-0850 N855FEAircraft Structures International Corp · Enid, OKBuilt 1990 · S/N 208B0203 N855JFg Flight LLC · Sanibel, FLBuilt 2021 · S/N 525-1093 N855MWMunguia Mario · Downey, CABuilt 1993 · S/N 258241 N855NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 40582 N855RJJw-N855rj LLC · Mcallen, TXBuilt 1981 · S/N 009 N855UPWheels Up Partners LLC · New York, NYBuilt 2015 · S/N FL-1024 N855VGM T B Investments LLC · Idaho Falls, IDBuilt 2008 · S/N FL-601 N8560ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64115 N8561ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 63585 N8562ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64171 N8563ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64172 N8564RAnderson Hans C · Leavenworth, WABuilt 1974 · S/N TH-534 N8564ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 42545 N8565ZUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 42533 N8566ZUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 64174 N8567ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 36928 N8568RDavenport Gregory · Edmond, OKBuilt 1974 · S/N TH-525 N8568ZUmb Bank Na Trustee · Salt Lake City, UTBuilt 2018 · S/N 64248 N8569ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 36954 N856ACVision Jet LLC · Fort Wayne, INBuilt 2004 · S/N 560-0656 N856DNDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 31967 N856FEFederal Express Corporation · Memphis, TNBuilt 1989 · S/N 208B0176 N856MABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B5084 N856NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31107 N856UPJjg Civil LLC · Thibodaux, LABuilt 2015 · S/N FL-1029 N8570WSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 36952 N8571ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 36957 N8572XSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64251 N8573ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 64250 N8574ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 63588 N8575ZSouthwest Airlines Co · Dallas, TXBuilt 2018 · S/N 63589 N8576ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 63590 N8577RPhillips Law Firm LLC · Marietta, GABuilt 1974 · S/N E-596 N8577ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64350 N8578QBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64349 N8579ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 63591 N857CGRbf Partners LLC · Chattanooga, TNS/N E-1128 N857DZDelta Air Lines Inc · Atlanta, GABuilt 2016 · S/N 31968 N857FEFederal Express Corp · Memphis, TNBuilt 1989 · S/N 208B0177 N857MABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B2422 N857NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30907 N857PRTravel Link LLC · Vienna, VAS/N 348 N8580ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64347 N8581ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64348 N8582ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64801 N8583ZBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 64799

Back to AD 2006-16-18 R1