Skip to content

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

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.

N69830United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44560 N69833United Airlines Inc · Chicago, ILBuilt 2014 · S/N 44565 N69835United Airlines Inc · Chicago, ILBuilt 2014 · S/N 60087 N69838United Airlines Inc · Chicago, ILBuilt 2014 · S/N 60121 N69839United Airlines Inc · Chicago, ILBuilt 2014 · S/N 60316 N69840United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42181 N69847United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42187 N69885United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42189 N69888United Airlines Inc · Chicago, ILBuilt 2015 · S/N 42191 N698DRAtm Asset Management LLC · Nashville, TNFirst renewal noticeS/N 421C0235 N698JTBank Of Utah Trustee · Salt Lake City, UTBuilt 1985 · S/N S550-0044 N698PTN698pt LLC · Clovis, NMBuilt 1985 · S/N S550-0060 N699ALBallard Aviation Inc · Newton, KSBuilt 1980 · S/N BE-83 N699BWBeech Transport LLC · Tarboro, NCBuilt 1999 · S/N BB-1658 N699CCC & C Market Research Inc · Fort Smith, ARBuilt 1999 · S/N LJ-1553 N699CJSra/Rombert Aviation LLC · Miami Beach, FLBuilt 2010 · S/N 525-0699 N699PSMcmillen Yachts Inc · Newport, RIBuilt 1998 · S/N TH1856 N699PVHealth Connect Life Sciences LLC · Newark, DEBuilt 2022 · S/N 208B5710 N699TPDoodle Aviation LLC · Burlington, NCBuilt 1985 · S/N FA-73 N69AKSimple Dimple LLC · Kalispell, MTBuilt 1968 · S/N E-91 N69BVJaguar Technologies Inc · Stanberry, MOS/N E-911 N69CJCook Benjamin · Meridian, IDBuilt 1968 · S/N E-15 N69CLTspy Services Inc · Nicholasville, KYBuilt 2000 · S/N TH-1949 N69ECAuto Midewst Inc · Niles, ILS/N 498 N69GDBonanza Five Flying Club Inc · Roswell, GABuilt 1989 · S/N E-2509 N69VHKolob Canyons Air Services Inc · Wilmington, DEBuilt 1982 · S/N 062 N69WSHurricane Joaquin LLC · Umatilla, FLS/N TH-780 N6BYDac Aero LLC · Jacksonville, FLBuilt 1991 · S/N TH-1629 N6CBPk Aviation LLC · Melbourne, FLBuilt 2024 · S/N 20800704 N6CHHodge Cleophas U · St Thomas, VIBuilt 1971 · S/N TH-131 N6FBTotman Darwin L Jr · Montgomery, LABuilt 1978 · S/N E-1318 N6FJFlying Farmer LLC · Wilmington, DEBuilt 1977 · S/N 97 N6GFFrodel Greg W · Pasco, WABuilt 1991 · S/N E-2657 N6HUHarding University Inc · Searcy, ARS/N FL-496 N6JTBandy Steven Trustee · Marana, AZBuilt 1979 · S/N E-1565 N6NCMeadowbrook Holdings LLC · Novi, MIBuilt 1997 · S/N 525-0217 N6NRSdi Aviation LLC · Rhinelander, WIBuilt 2004 · S/N 258701 N6RVNrv Aviation LLC · Pleasant Grove, UTBuilt 2026 · S/N 208B5929 N6SM6sm LLC · West Palm Beach, FLBuilt 2017 · S/N FL-1093 N6TRJmr Aviation LLC · Midland, TXBuilt 2001 · S/N 560-0573 N6UBCitation525 Holdings LLC · Potomac, MDBuilt 1996 · S/N 525-0127 N6VJN6vj LLC · Coleman, FLS/N LA88 N6VUPro Motive LLC · Glade Spring, VABuilt 1975 · S/N TH-665 N6WKSushi Aviation Holdings LLC · Raleigh, NCBuilt 1976 · S/N E-807 N6WWWintons Wings LLC · Bardstown, KYBuilt 1973 · S/N TH-358 N6XZKahler Automation Corp · Fairmont, MNBuilt 1982 · S/N E-2047 N6ZMStauf Air LLC · Germantown, TNBuilt 1990 · S/N E-2574 N70Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-5 N700BAAviation Inventory Resources Inc · Alvarado, TXBuilt 1980 · S/N BE-84 N700CJBruun Aircraft LLC · Portland, ORBuilt 1993 · S/N 525-0027

Back to AD 2006-16-18 R1