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.

N367WWVmrfalcon50 LLC · Evans, GAS/N 367N3680RYatra Global LLC · Bedford, MABuilt 1980 · S/N E-1717N3680UMoughon Kirby W · Melbourne, FLBuilt 1980 · S/N E-1718N3681GRed Wolf Aviation LLC · Wilmington, DEBuilt 1980 · S/N TH-1157N36829Prime Aviation LLC · Wilmington, DEBuilt 1980 · S/N E-1720N3682ZIliamna Air Taxi Inc · Iliamna, AKBuilt 1980 · S/N TH-1159N3689ULeonard Robert E · Mattoon, ILBuilt 1980 · S/N E-1733N368BEDos Amigos Transport LLC · Austin, TXBuilt 2000 · S/N 560-0546N368HPHigh Performance Aircraft Inc · El Cajon, CABuilt 1981 · S/N E-1833N368JEJones Enterprises · Nacogdoches, TXBuilt 1980 · S/N TH-1145N368JHUrsine L Attitudes Ltd · Richland, WABuilt 1981 · S/N E-1920N368POfferaire Inc · Lebanon, NJBuilt 1995 · S/N E-2942N368SSSierra Aviation Holdings LLC · Colorado Springs, COS/N 368N368VKranz Daniel · Hastings, MNBuilt 1968 · S/N E-21N36900Bas Part Sales LLC · Greeley, COBuilt 1980 · S/N E-1739N3690FWv Gastro & Endo LLC · Wheeling, WVBuilt 1980 · S/N LJ-921N3694LRegistered aircraftBuilt 1980 · S/N TH-1176N3695NWalton Jerry Prince Jr · Monticello, FLBuilt 1980 · S/N TH-1192N3695WSuarez-Ballardo Jorge Luis · Glendale, AZBuilt 1980 · S/N LJ-924N36987Westflight LLC · Yuma, AZBuilt 2004 · S/N BB-1887N36988Bank Of Utah Trustee · Salt Lake City, UTS/N FL488N3698D98d Aviation LLC · Dyersburg, TNBuilt 1980 · S/N E1746XLN3699AWeskap Hangar Management LLC · West Grove, PABuilt 1979 · S/N E-1621N369EASchool Of Missionary Aviation Technology · Ionia, MIBuilt 1985 · S/N RJ-2N369GGulley Cameron L · Eastland, TXBuilt 1968 · S/N E-44N369LSLonestar Aviators LLC · Houston, TXBuilt 1990 · S/N 560-0084N369MKKcha LLC · Chattanooga, TNS/N FL-369N369MWTextron Aviation Inc · Wichita, KSS/N FL-1369N369RKKrum Force 1 LLC · Wichita, KSBuilt 1976 · S/N 421C0072N369RMRothschild Jonathan Trustee · Tucson, AZBuilt 1976 · S/N 421C0071N369RSEarly Bird Air LLC · Lawrence, MIBuilt 1999 · S/N LJ-1571N369SACaton William D · Irving, TXBuilt 2001 · S/N E-3369N369UBAlliance Air Parts Acquisitions Corp · Oklahoma City, OKS/N 258232N369WTSterling John · Port Lavaca, TXBuilt 1978 · S/N LW291N36AAPortnoy Ralph · Hollywood, MDBuilt 1978 · S/N E-1217N36ABNg Turf LLC · Whitesburg, GABuilt 1979 · S/N E-1560N36ARArkansas Department Of Aeronautics · Little Rock, ARBuilt 1991 · S/N E-2620N36ASMoore Brothers Company Inc · Staunton, VABuilt 1977 · S/N E-1009N36AVCook Greg R · Willis, TXBuilt 1992 · S/N TH-1657N36AXNorth Flight Air LLC · Ann Arbor, MIBuilt 1990 · S/N E-2579N36BGPerez Colbert Md Pa · Lubbock, TXBuilt 1979 · S/N E-1546N36BHHobo LLC · Milford, IABuilt 1977 · S/N E-1056N36BKBiro Manufacturing Co Inc · Marblehead, OHBuilt 1991 · S/N E-2604N36BNMarshall Baron Robert · Marion, MTBuilt 1977 · S/N E-1058N36BRRegistered aircraftBuilt 1982 · S/N E-2000N36BVSilver Star Aviation LLC · Magee, MSS/N E-3538N36CNBonanza Aircraft Partners LLC · Sugar Land, TXBuilt 2005 · S/N E-3623N36CPTitan Aviation LLC · Wilmington, DEBuilt 2004 · S/N 5600654N36CSHowerton Kurt · Groveland, CABuilt 1977 · S/N E-973N36CTExecutive Mission LLC · Round Rock, TXBuilt 1990 · S/N TH-1579
Back to AD 2006-16-18 R1