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.

N78540United Airlines Inc · Chicago, ILBuilt 2017 · S/N 63646 N7854RHulsey Mark T Sr · Prescott, AZBuilt 1968 · S/N E-133 N785FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0283 N785JPGuardian Flight LLC · Lewisville, TXBuilt 2004 · S/N LJ-1710 N785PDOrchard Elms LLC · North Ogden, UTBuilt 2025 · S/N 525-1193 N785RWWiseman Russell · Keller, TXBuilt 1968 · S/N E-19 N785WCWillwork 4 Jeta LLC · Houston, TXBuilt 1978 · S/N BB-425 N785WWAce Aviation LLC · Phoenix, AZBuilt 1999 · S/N 208B0792 N7867RBlue House Veterinary LLC · Buffalo Lake, MNBuilt 1969 · S/N E-136 N7867THoldsworth David · Crystal City, TXBuilt 1989 · S/N 560-0020 N786DDTransouth Leasing LLC · Longview, TXS/N BB-1171 N786FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0284 N786MXMadix Inc · Terrell, TXBuilt 2008 · S/N 560-0786 N786SCBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N FL-1267 N786TSTurnquist Paul Sr · Lincoln, MEBuilt 1976 · S/N E-901 N786WWWestwind Aviation Inc · Phoenix, AZBuilt 2004 · S/N 208B1099 N786ZAZulu Air LLC · Opa Locka, FLBuilt 1994 · S/N LJ1388 N787CCMegaship Ventures LLC · Baytown, TXBuilt 1985 · S/N TH-1490 N787CVRowley Aviation Inc · Fort Lauderdale, FLBuilt 1994 · S/N 650-7037 N787DKBlue Skies 4 LLC · Staunton, VAS/N FL159 N787FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0285 N787JKMark M Jackson Do LLC · Sarasota, FLS/N E-1159 N787MRMoon Aviation LLC · Oklahoma City, OKBuilt 1997 · S/N E-3144 N787RAHorizon Management LLC · San Juan, PRBuilt 2016 · S/N 208B5335 N787TTMjw Aviation LLC · Beaumont, TXS/N LJ-787 N7883RMcdaniel Kennard J · Kansas City, MOBuilt 1969 · S/N E-138 N7886ABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35122 N7886LN7886l LLC · Brighton, COBuilt 1968 · S/N E-10 N7887ABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35123 N7888ABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35124 N788CF3w Group Inc · Hot Springs, ARBuilt 1977 · S/N TH-870 N788FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0286 N788JWNorth Fork Place LLC · Bozeman, MTBuilt 2020 · S/N 525-1050 N788XABank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 33788 N789AHApple Realty Group Inc · Richmond, VABuilt 2016 · S/N 208B5281 N789CARegistration Pending · Apopka, FLRegistration pendingBuilt 1994 · S/N 074 N789CTKingfisher Associates LLC · Wilmington, DEBuilt 1981 · S/N BB-820 N789FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0287 N789HAClark County Jets LLC · Sellersburg, INBuilt 1998 · S/N 258354 N789JArr Planes LLC · Chattanooga, TNBuilt 1984 · S/N E-2145 N789JHThomas Matthew S · Denver, COBuilt 1969 · S/N E-167 N789JSArs Air LLC · Newport Beach, CABuilt 2008 · S/N 560-0801 N789LLUS Special Operations Command · Macdill Afb Tampa, FLBuilt 2003 · S/N FL-386 N789PZWalters Aviation Group LLC · San Diego, CABuilt 1984 · S/N TH-1424 N789RPBrindle Concepts LLC · Hanover, PABuilt 1975 · S/N 421C0009 N78BABuckley Aviation LLC · Swainsboro, GABuilt 1998 · S/N LJ1529 N78BEHappy Planes LLC · Boyertown, PABuilt 1978 · S/N E-1178 N78BFSandbar Air LLC · Saint Petersburg, FLBuilt 1972 · S/N E-331 N78CTCt Air LLC · Middletown, DES/N LJ-1705 N78DARegistered aircraftBuilt 1976 · S/N BE-11

Back to AD 2006-16-18 R1