OpenAirDocs.org
AD 2006-16-18 R1

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
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.

N3AHEat Veggies 3 LLC · Savannah, GABuilt 1987 · S/N FA-130N3AWArrowhead Burbank Inc · Burbank, OKS/N FL-491N3BAConstruction Enterprises Inc · Franklin, TNBuilt 1997 · S/N FL-181N3DJHatch Hyrum G · Chandler, AZS/N 421C0011N3DPAircraft Holding Solutions LLC · Newark, DEBuilt 1981 · S/N 334N3GCTexas Air & Space Museum · Amarillo, TXBuilt 1973 · S/N LJ-576N3GNR-Air Inc · Wilmington, DES/N 501-0090N3HBSunset Aviation LLC · Port Angeles, WABuilt 1979 · S/N BB-453N3JSOriole Capital LLC · Wilmington, DEBuilt 2020 · S/N 525-1052N3KNKing Martin E · Friendswood, TXBuilt 1980 · S/N E-1770N3KWBeute Walter A · Palatka, FLBuilt 1947 · S/N D-828N3LGTuthill James G Jr · Burr Ridge, ILBuilt 2011 · S/N 20800525N3LHSilverstar Partners LLC · Houston, TXFirst renewal noticeS/N 037N3LSConcept Management Company LLC · Spartanburg, SCBuilt 1977 · S/N LW-245N3MEAero F90 LLC · Oxnard, CABuilt 1980 · S/N LA-101N3MFJ & K Aviation Inc · Conway, ARBuilt 1983 · S/N LA209N3MHN3mh LLC · Kalispell, MTBuilt 1985 · S/N BB-1228N3MUAero Equities LLC · Ventura, CAS/N TH-1864N3NCNorth Carolina Dept Transportation · Raleigh, NCBuilt 2007 · S/N BB-1976N3PEJabr Aviation LLC · Milford, IABuilt 1977 · S/N TH-820N3PXAirtime LLC · Mont Belvieu, TXBuilt 1984 · S/N BB-1173N3RBSx Transport LLC · Portland, ORBuilt 1989 · S/N 560-0035N3RKCorinthian LLC · Southgate, MIS/N 31T-8166022N3SWAero Burro LLC · San Antonio, TXBuilt 2002 · S/N 525-0501N3TCRegistration Pending · Clewiston, FLRegistration pendingBuilt 2011 · S/N 20800527N3WTCb LLC · Mobile, ALBuilt 1979 · S/N 5010088N400AYVann Air Investments LLC · Williams, CAS/N FL-428N400BSMb Aviation Inc · Larue, TXS/N 421C1089N400DAFive Saguaro Leasing LLC · Albuquerque, NMBuilt 1984 · S/N FA-11N400DMAlborn Mary L · Eagle River, AKS/N E-748N400EMGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N LJ-1601N400GPIcmc Idaho LLC · Salinas, CAS/N 423N400GWGpw LLC · Laurel Springs, NCBuilt 1997 · S/N BB-1583N400KSNbs Air LLC · Creve Coeur, MOBuilt 1990 · S/N 5600041N400MZParker Long LLC · Lexington, NCBuilt 2025 · S/N 525-1400N400RVMach Point Nine LLC · Phoenix, AZBuilt 1979 · S/N LJ-853N400SCN400sc LLC · Walterboro, SCBuilt 1982 · S/N BB-1040N400SLTurbo Air Charter LLC · Boise, IDBuilt 1980 · S/N BB-697N400WSHatbright Farm LLC · Wilmington, DEBuilt 1981 · S/N 31T-8166044N401AESmith Jay D · Shreveport, LABuilt 1976 · S/N E865N401DRApex Aeronautical Group LLC · Jenks, OKBuilt 1980 · S/N TH-1138N401HTTailwinds LLC · Houston, TXBuilt 1986 · S/N S5500115N401JWWatts John I · Murchison, TXBuilt 1975 · S/N 46N401NSNs 300 LLC · Atlanta, GABuilt 1985 · S/N FA-28N401SUnderhill Holdings LLC · East Haven, CTBuilt 2015 · S/N 208B5261N401SBGoertzen Joshua K · Wasilla, AKBuilt 1975 · S/N TH-641N40269Freefall Express Inc · Gardiner, NYBuilt 1968 · S/N 152N402ASAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 41189N402EASneed Leasing LLC · Nashville, TNBuilt 2001 · S/N E-3402N402RX56 Express LLC · Willmar, MNBuilt 1988 · S/N FA-163
Back to AD 2006-16-18 R1