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.

N17KKRiverbend Aviation LLC · Hernando, MSBuilt 1998 · S/N LJ-1318 N17LJGenetech Animal Reproduction LLC · Purcell, OKBuilt 2000 · S/N 525-0372 N17LKAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1984 · S/N 431 N17LPN17lp LLC · Amarillo, TXBuilt 1985 · S/N S550-0111 N17NMCentral Virginia Aviation Inc · Petersburg, VABuilt 1977 · S/N LW-237 N17NNRusty Wallis Aviation LLC · Dallas, TXBuilt 1999 · S/N 6507099 N17TVBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 258622 N17TXTriangle 5 Ranch LLC · Longview, TXBuilt 1992 · S/N 560-0166 N17USMarmac Inc · Hellertown, PABuilt 1976 · S/N E-851 N17VAOptimal Aviation Services LLC · Visalia, CABuilt 1980 · S/N BB-670 N17VBN17vb LLC · Nacogdoches, TXBuilt 1997 · S/N 525-0206 N17WCHm Aviation Holdings LLC · Fort Pierce, FLBuilt 1997 · S/N FL-168 N17WGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N BB-1602 N17WNKadans Air LLC · West Bloomfield, MIS/N E-3536 N17YLYowell Legacy Aviation LLC · Killeen, TXBuilt 1990 · S/N FL-1 N1800VRegistered aircraftS/N E-1858 N1801BSjd Flight LLC · Houston, TXBuilt 1974 · S/N LJ-634 N1801VSouthwind Aviation LLC · Hays, KSS/N E-1859 N1803XTrtt Investments LLC · Tahlequah, OKBuilt 1981 · S/N E-1864 N1805RFlying Ventures LLC · Middletown, DEBuilt 1981 · S/N E-1867 N1806LHarrigan Timothy · Folsom, CABuilt 1976 · S/N E-836 N1807LCobra Industries Aeronautical · Wrightwood, CABuilt 1976 · S/N E-837 N1807NDouble Barrel Aviation LLC · Fort Valley, GABuilt 1981 · S/N TH-1263 N1809AHi-Ho Air LLC · Wilmington, DEBuilt 1981 · S/N E-1872 N180BBailey Aviation LLC · Roswell, NMBuilt 1994 · S/N 560-0278 N180GCZuni LLC · Kirkland, WABuilt 2009 · S/N 208B2085 N180HLTrinity Capitol Leasing LLC · Fort Pierce, FLBuilt 1992 · S/N 560-0188 N180NEJunction Medical Office P C · Jackson Heights, NYS/N NA0401 N1810XAviation Trust Company LLC Trustee · Oklahoma City, OKS/N TH1266 N1811YCarhonik Enterprises LLC · Piney Flats, TNBuilt 1981 · S/N E-1877 N1813BRr Aviation Services LLC · Wichita, KSBuilt 1981 · S/N E-1879 N18142Aviation Trust Co LLC · Oklahoma City, OKBuilt 1981 · S/N TH-1270 N1814SUnited Mobile Auctions Aviation LLC · Mooresville, NCBuilt 1981 · S/N E-1883 N1815FIss Holdings LLC · Lady Lake, FLBuilt 1981 · S/N E-1886 N1817LLorenzo Timothy A · Eureka, CABuilt 1976 · S/N E-839 N1817SClear Skies LLC · Stuart, FLBuilt 1981 · S/N TH-1271 N1818XBeech Jet 324 LLC · Delray Beach, FLBuilt 2000 · S/N E-3302 N1818YLemonides Charles S · Bridgehampton, NYBuilt 1981 · S/N E-1888 N1819LBlack Kettle Inn LLC · Cabool, MOS/N E-838 N181GMid South Agricultural Products Inc · Lafayette, LAS/N S550-0006 N181RK330 Am Holding Corp · Miami, FLBuilt 1991 · S/N 515 N181SGBiotechnologies LLC · Chippewa Falls, WIS/N 560-0181 N1820FHamilton Aviation LLC · Waycross, GABuilt 1981 · S/N E-1893 N1820LSafeco Leasing LLC · Port Alsworth, AKBuilt 1976 · S/N E-843 N18220United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28929 N18223United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28932 N18243United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28806 N18253Glass Anthony A Trustee · Plano, TXBuilt 1977 · S/N E-1067 N1825SEngebretson Christopher D · Greenville, INS/N E-1898 N18265Strance Gordon M · Sevierville, TNBuilt 1987 · S/N E-2381

Back to AD 2006-16-18 R1