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.

N571APOreilly II Aviation Corp · Springfield, MOBuilt 2011 · S/N 560-0805 N571ASUmb Bank Na Trustee · Salt Lake City, UTS/N 32904 N571AWCsi 135 Division LLC · Albuquerque, NMBuilt 2000 · S/N FL-290 N571DWTextron Aviation Inc · Wichita, KSBuilt 2025 · S/N 208B5878 N571GTConrad Aviation LLC · Forest Hill, LABuilt 2021 · S/N 525-1089 N571SCGospel Ministries International Inc · Mc Donald, TNS/N 20800571 N571TMBranhill Plantation Reserve LLC · Wilmington, DEBuilt 1979 · S/N BB-571 N572CHHarrison Chalfant & Christensen Holdings LLC · Midland, TXBuilt 2021 · S/N FL-1261 N572RSB2b Aviation LLC · Leesburg, VABuilt 2026 · S/N 525-1421 N572TMJohnson Eric N · Port Matilda, PABuilt 1984 · S/N E-2125 N572WCRegistration Pending · Bullard, TXRegistration pendingBuilt 1981 · S/N BB933 N5734N5734 LLC · Katy, TXBuilt 1997 · S/N 258304 N573BABering Air Inc · Nome, AKBuilt 2015 · S/N 208B5220 N573CMFlightline Holdings LLC · New Orelans, LABuilt 1999 · S/N 525-0352 N57439United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33534 N574HALow Approach LLC · Wilmington, NCBuilt 2001 · S/N TH-1975 N574KKurz Douglas · Houston, TXS/N TH-1901 N574SBRj Group Investments LLC · Lawton, OKBuilt 1972 · S/N E-312 N574TATango Alpha Management Co LLC · Georgetown, SCBuilt 2026 · S/N 525-1406 N574WDLathrop Frederic W · Dayton, OHBuilt 1997 · S/N TH-1831 N575CLilly David E · Allentown, PABuilt 1971 · S/N LJ-532 N575CFChestnut Aviation LLC · Lewes, DEBuilt 1990 · S/N 560-0079 N575CWWheeler Dealer LLC · Wilmington, DES/N TH-2075 N575GWNeuse Aviation LLC · Smithfield, NCBuilt 2001 · S/N E-3390 N575HARiver City Aircraft LLC · Sellersburg, INS/N 650-7009 N575JDArctic One LLC · Fairbanks, AKBuilt 1997 · S/N 208B0595 N575KTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1988 · S/N 650-0158 N575RRemme Kaare · San Marcos, TXBuilt 1996 · S/N 208B0550 N575RDSteelwood Partners LLC · Hawthorne, CABuilt 2000 · S/N FL-288 N575SGOsage Aviation LLC · Yates Center, KSBuilt 1985 · S/N S550-0064 N575TMHauck Enterprises Ltd · Port Neches, TXBuilt 2014 · S/N 525-0838 N576CLAci Aviation LLC · Victor, MTBuilt 1979 · S/N BB-576 N576LLLandlocked Company LLC · Dover, DES/N 576 N576PVHamilton Victor · Jupiter, FLBuilt 1982 · S/N 383 N576SATvpx Aircraft Solution Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 208B5824 N577ANFifteen Seventy Aviation LLC · Greenville, TXS/N 060 N577ASAlaska Airlines Inc · Seattle, WABuilt 2007 · S/N 35186 N577KGMccloy Mark T · Tatum, NMS/N 421C0906 N577KPPelican Sky LLC · Abbeville, LABuilt 2000 · S/N 525-0389 N577PWLa Aviation LLC · Cary, NCBuilt 1996 · S/N FL-133 N577RJAviation Trust Company LLC · Oklahoma City, OKBuilt 1981 · S/N 421C1108 N577RWBlue South Adventures LLC · Westlake, TXBuilt 1997 · S/N 560-0434 N577TMMack Air LLC · Ivanhoe, CABuilt 2017 · S/N FL-1107 N577WGta Air Inc · Addison, TXBuilt 1973 · S/N TH-375 N577WCWellons King Air LLC · Dunn, NCBuilt 1998 · S/N FL213 N577XWJetreed LLC · Mount Pleasant, SCBuilt 1990 · S/N 560-0083 N578CFInfinity Aviation LLC · Mandan, NDBuilt 2017 · S/N 525-0965 N578GCKamaka Air LLC · Honolulu, HIBuilt 2010 · S/N 208B2153 N578GGN578gg LLC · Amarillo, TXBuilt 1985 · S/N S550-0079 N578KAEcho Bravo Aviation II LLC · Wilmington, DEBuilt 2017 · S/N FL-1110

Back to AD 2006-16-18 R1