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.

N498CSMmu-Cit-Aviation LLC · West Orange, NJS/N 650-0180 N498GGPleasant Aircraft Leasing LLC · Newbury Park, CAFirst renewal noticeBuilt 2009 · S/N 208B2118 N498RKCbcc King Air Inc · Bakersfield, CABuilt 2023 · S/N FL-1324 N499PANe Charters LLC · South Jordan, UTBuilt 2005 · S/N 258739 N499RCCentral Virginia Aviation Inc · Petersburg, VAS/N S550-0090 N49CTJog001inc · Lewes, DES/N 314 N49DCenturian 94n LLC · Ripon, CABuilt 1974 · S/N TH-542 N49DKKts Holdings LLC · Elk Grove Village, ILBuilt 1990 · S/N 560-0075 N49FBFlying Bullet LLC · Grand Island, NEBuilt 1988 · S/N FA-153 N49HRBon-36 Ltd · Shavano Park, TXBuilt 1993 · S/N E-2790 N49JHWildhorse 340 LLC · Kalispell, MTBuilt 2017 · S/N 525-0959 N49JLPalmetto Aviation Solutions LLC · Woodruff, SCBuilt 1975 · S/N E-746 N49JPSumner Properties LLC · Somersworth, NHBuilt 1990 · S/N LJ1243 N49KCBeech Transportation Inc · Eden Prairie, MNBuilt 1977 · S/N BB-318 N49LDMckee Foods Transporation LLC · Collegedale, TNBuilt 2008 · S/N 560-0803 N49LFHerrera Gilbert Jr Trustee · Arcadia, CABuilt 1979 · S/N E-1510 N49LLSilver Wing Aviation LLC · Wilmington, DEBuilt 1981 · S/N BB-843 N49MNAlliance Air Parts Acquisitions Corp · Oklahoma City, OKS/N 019 N49NTCheyenne Aircraft LLC · Searcy, ARBuilt 2024 · S/N 525-1170 N49PSZulu Time LLC · Norfork, ARBuilt 1978 · S/N E-1227 N49RDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1975 · S/N BD02 N49SBGarcia Edward · Ooltewah, TNBuilt 1991 · S/N E-2661 N49SJUnited States Department Of Interior · Boise, IDBuilt 1974 · S/N 423 N49WCWest Coast Aircraft Shares LLC · Santa Ana, CABuilt 1996 · S/N FL-144 N4EQUsi Leasing LLC · Garden City, KSBuilt 1984 · S/N E-2205 N4GAAircraft Owners And Pilots Association · Frederick, MDBuilt 1989 · S/N E-2466 N4HESouth Florida Aerobatics LLC · West Palm Beach, FLBuilt 1976 · S/N TH-787 N4HFBat Plane LLC · Memphis, TNS/N E-2421 N4JADiamond Aviation LLC · Tuscaloosa, ALBuilt 1994 · S/N TH-1714 N4KFAirkap LLC · Sioux City, IABuilt 2002 · S/N FL-354 N4LCCorbett Perry Howard III · Ferriday, LABuilt 1991 · S/N E-2617 N4LGHmt Leasing LLC · Seabrook, TXBuilt 2001 · S/N FL-326 N4LWWilliams Jason Allen · Cypress, TXBuilt 1992 · S/N TH-1652 N4MZBank Of Utah Trustee · Salt Lake City, UTS/N 421C0829 N4QLFremont Motor Company Inc · Lander, WYBuilt 1981 · S/N BB-942 N4QNLabutte LLC · Dearborn, MIBuilt 1993 · S/N 650-7031 N4TLMorningstar Aviation II Inc · Wilmington, DEBuilt 2001 · S/N 560-0587 N4TMJtm Ranches Equipment LLC · Dallas, TXBuilt 1991 · S/N 560-0105 N4VHFoster Chad H Jr · Uvalde, TXBuilt 1977 · S/N 421C0435 N4WZMulligan Peter · Richardson, TXBuilt 1970 · S/N TH117 N4YSRegistered aircraftBuilt 1992 · S/N FL-82 N4ZLFlying 5 Llcf · Johnson City, TNBuilt 1997 · S/N 560-0448 N50Textron Aviation Inc · Wichita, KSS/N FL-1375 N5001XVirginia Brian · Maple Grove, MNBuilt 2002 · S/N E-3481 N500BAKw Plastics · Troy, ALBuilt 1997 · S/N TH-1814 N500BJAir Metro Leasing Inc · Wilmington, DEBuilt 1978 · S/N 242 N500CFPool Plane LLC · Seattle, WABuilt 2000 · S/N 303 N500CMM & M Aviation LLC · Portsmouth, NHBuilt 1979 · S/N E1505 N500CRElite Medical Air Transport LLC · El Paso, TXBuilt 1980 · S/N BB-714 N500EQTxsd Holdings LLC · Amarillo, TXBuilt 1994 · S/N LJ-1387

Back to AD 2006-16-18 R1