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.

N30LTJuans Adios LLC · Newark, DES/N 421C0290 N30LXN492a LLC · Goodyear, AZBuilt 1984 · S/N 438 N30MSkysouth Aviation Inc · Durham, NCBuilt 2003 · S/N 525-0506 N30MCMadden Contracting Company LLC · Sibley, LABuilt 2022 · S/N FL-1298 N30MHLyle Machinery Co · Richland, MSBuilt 2006 · S/N FL-493 N30MRBergen Food Enterprises Inc · Norman, OKBuilt 1978 · S/N 225 N30MYTwin State Aviation LLC · Davenport, IABuilt 2016 · S/N FL1062 N30NMTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 525-1420 N30NSHilltop LLC · Rye, NYBuilt 2014 · S/N 525-0835 N30PJHighland Paving Co LLC · Eastover, NCBuilt 1999 · S/N LJ-1579 N30PTGas Aviation LLC · Decatur, TNBuilt 1976 · S/N 421C0157 N30RPCommunications Laboratories Inc · Melbourne, FLBuilt 1982 · S/N E-2050 N30SETradewinds 12/21 Inc · Denison, TXBuilt 1977 · S/N BB313 N30SLAppel Neal C · Prescott, AZBuilt 1972 · S/N E-338 N30SMState Of Mississippi · Pearl, MSS/N FL-99 N30TBAlbert Lea Airport Inc · Albert Lea, MNBuilt 1970 · S/N TH-74 N30TEV1vr LLC · Wilmington, DEBuilt 1980 · S/N 152 N30VRWd Journeys Inc · Downers Grove, ILBuilt 2002 · S/N 5250481 N30WRInfotech Management Inc · San Diego, CANon-citizen corporation, flight hours not reportedBuilt 1983 · S/N 380 N3101VWallace William D · Brunswick, GABuilt 1947 · S/N D-520 N3105WDavis Kenneth D · Ft Wayne, INBuilt 1973 · S/N E-494 N31075Camden Group Inc · Boston, MABuilt 1988 · S/N E-2415 N3109CVicjen LLC · Bloomington, ILBuilt 1987 · S/N E-2400 N310CHWatermakers Air Inc · Fort Lauderdale, FLBuilt 2016 · S/N 208B-5328 N310DEDelta Air Lines Inc · Atlanta, GABuilt 2009 · S/N 29665 N310ECState Of Tennessee · Nashville, TNBuilt 1988 · S/N TH-1534 N310EJZenodro At Tranquility Aviation LLC · Clermont, FLBuilt 2006 · S/N 258767 N310TVHaushold Aviation LLC · Shelbyville, TNBuilt 1978 · S/N E-1340 N310TXRiddles Group Inc · Rapid City, SDBuilt 1988 · S/N FA-140 N3111DMonarch Air Services LLC · Ballwin, MOBuilt 1994 · S/N E-2874 N3111VStewart Ladd E · Augusta, KSBuilt 1947 · S/N D-533 N31121Full Flaps 2 LLC · Peachtree City, GABuilt 1988 · S/N E-2428 N3112YWykoff Donald W · West Chester, OHBuilt 1988 · S/N E-2410 N31143Mjj Aircraft Inc · Wilmington, DEBuilt 1988 · S/N E-2443 N3114VWheeler Jack W · Greensboro, NCBuilt 1947 · S/N D-536 N3114YN635v LLC · Nacogdoches, TXBuilt 1988 · S/N E-2441 N3115WBenson James M · Cleveland, TNBuilt 1973 · S/N E-497 N3116BIntegrity Air LLC · Jefferson, TXBuilt 2002 · S/N 560-0625 N3116WMathis Bettina Jary · Dripping Springs, TXBuilt 1973 · S/N E-499 N3118HAtlantic Aviation Group Inc · Miami, FLBuilt 1994 · S/N TH-1718 N3119TRiverwind Strategic Solutions LLC · Lewes, DEBuilt 1994 · S/N E-2878 N3119VMartin Lynn E · Princeton, TXBuilt 1947 · S/N D-543 N311BC311bc LLC · Channelview, TXBuilt 1976 · S/N 421C0132 N311BPWls Enterprise LLC · Portland, ORBuilt 2001 · S/N 314 N311CASouthern Wings LLC · Shreveport, LABuilt 1977 · S/N 421C0252 N311CPKwihnai Flyers LLC · Troy, OHBuilt 2024 · S/N 525-1165 N311CTShahriari David B · Anaheim, CABuilt 1976 · S/N E-853 N311FLAlliance Aviation Group LLC · Wilmington, DEBuilt 1997 · S/N 258338 N311GCRte Enterprises Inc · Canoga Park, CABuilt 1980 · S/N LA-55 N311GTUmb Bank Na Trustee · Salt Lake City, UTBuilt 1995 · S/N 26316

Back to AD 2006-16-18 R1