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.

N323MLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N FL-1049N323NENcw Aircraft LLC · Wenatchee, WABuilt 1997 · S/N 560-0442N323PXFehrs Aviation LLC · Seminole, TXBuilt 2002 · S/N BB-1803N32404United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30121N3240NAir Services Of Mississippi Inc · Mccomb, MSBuilt 1995 · S/N E-2980N3243BKcirro LLC · Portland, ORBuilt 1999 · S/N E-3243N3244VMalouf Jeannette D H · Palm Harbor, FLBuilt 1947 · S/N D-689N3246BRb3246b LLC · La Follette, TNBuilt 1995 · S/N TH-1746N3246RRegistered aircraftBuilt 1995 · S/N E-2946N3246SInsync Investments LLC · Dover, DEBuilt 1999 · S/N LJ-1576N3247XExcalibur Aviation LLC · Spencer, IABuilt 2000 · S/N E-3347N3248LPreferred Management Corp · Shawnee, OKBuilt 1995 · S/N TH-1748N3248TBrydon Robert J · Austin, TXBuilt 1995 · S/N E-2948N3249DBielanski Allan · Larkspur, COBuilt 1995 · S/N E-2949N3249JSelge Leasing Inc · Niles, MIS/N E-3349N324BDGodwin Aviation LLC · Dunn, NCBuilt 2008 · S/N 525-0674N324JWVip Jet Transportation Inc · Bishop, CABuilt 1981 · S/N 324N324LMCirrus Wings LLC · Jefferson City, MOBuilt 1996 · S/N 560-0395N324QLove Charles Keith · Asheville, NCBuilt 1999 · S/N TH-1909N3250VK & J Air Services Ltd · Midland, TXFirst renewal noticeBuilt 1995 · S/N BB-1523N3252JBas Part Sales LLC · Greeley, COS/N E-3252N3252REllis Eric Lee Trustee · Lincoln, CABuilt 1995 · S/N E-2952N3252YPa1 208b-1088 LLC · Fort Lauderdale, FLBuilt 2004 · S/N 208B1088N3254GEdling Tyrell R · The Dalles, ORBuilt 1995 · S/N E-2954N3255VAcker Timothy G · Gig Harbor, WABuilt 1947 · S/N D-702N325DCGmg Aviation LLC · Ehrhardt, SCBuilt 1981 · S/N TH-1292N325EXFalcon 325 LLC · Fort Pierce, FLBuilt 2002 · S/N 325N325FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 28325N325JFN325jf Operating LLC · Dallas, TXBuilt 1990 · S/N 6500181N325RDLow Tide LLC · Riverside, IABuilt 1995 · S/N 650-7056N3260FGilbert Aviation Inc · Wilmington, DEBuilt 1995 · S/N TH-1760N3261CHeyman Steven · San Mateo, CABuilt 1996 · S/N TH1785N3261VBaldwin Larry Lee · Clarinda, IABuilt 1947 · S/N D-708N3262REaglemed LLC · Wichita, KSBuilt 1999 · S/N LJ-1562N3262VAbernathy Richard M · Overland Park, KSBuilt 1947 · S/N D-709N3262XDns Aviation LLC · Fulton, CABuilt 1995 · S/N E-2962N3263CEaglemed LLC · Wichita, KSBuilt 1996 · S/N LJ-1432N3263NGuardian Flight LLC · Lewisville, TXBuilt 1999 · S/N LJ-1563N3268VObrien Joseph F IV · Pierson, FLBuilt 1947 · S/N D-716N3269HEom LLC · Little Rock, ARBuilt 1996 · S/N E-2999N3269VRegistered aircraftBuilt 1947 · S/N D-717N326AJVanderloop Equipment Inc · Brillion, WIBuilt 1978 · S/N BB-396N326DWAbaco III LLC · Wellington, FLBuilt 2012 · S/N FL-824N326FLUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 28326N326JKRiver Bank Aviation LLC · Dover, DEBuilt 2003 · S/N 525-0511N326KWBering Air Inc · Nome, AKBuilt 1990 · S/N BB1360N326RTPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 1979 · S/N BB553N326TRTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIS/N 20917N326WRRoquemore William A Jr · Lakeland, GABuilt 1966 · S/N 308N3270JBerry Matthew G · Creedmoor, NCBuilt 1996 · S/N TH-1770
Back to AD 2006-16-18 R1