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.

N200HKHck Aviation LLC · Jupiter, FLBuilt 2001 · S/N BB-1772 N200JLCrest Trading Company · Bakersfield, CABuilt 1975 · S/N BB-40 N200JREngelman Acres Ltd · Edinburg, TXBuilt 1983 · S/N BB-1123 N200KSKapowsin Air Sports Ltd · Shelton, WABuilt 1986 · S/N 208B0001 N200LFAeromarine Holdings LLC · Waukesha, WIBuilt 1989 · S/N 20800149 N200LHEagle Nation Aviation LLC · Macon, GABuilt 1992 · S/N 650-7005 N200NDNorth Dakota Department Of Transportation · Bismarck, NDBuilt 1998 · S/N BB-1612 N200NVAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33341 N200NWViking Transport LLC · Saint Louis Park, MNBuilt 1999 · S/N BB-1691 N200PHPrairie Ventures Aviation LLC · Worthington, MNFirst renewal noticeBuilt 1977 · S/N BB-238 N200PZBeech Transportation Inc · Eden Prairie, MNBuilt 1978 · S/N BB-410 N200RELw164 Inc Trustee · Wilmington, DEBuilt 1975 · S/N LW-164 N200RMMps Enterprises LLC · North Platte, NEBuilt 1973 · S/N LW-45 N200RRTexas Dept Of Criminal Justice · Huntsville, TXBuilt 1987 · S/N BB-1282 N200SLAtfo LLC · Wildwood, MOBuilt 2001 · S/N 525-0461 N200TEJohnson William L · Fruitland, IDBuilt 1986 · S/N E-2351 N200TNI & V Aviation LLC · Missoula, MTBuilt 1978 · S/N 421C0444 N200UOhio University · Albany, OHBuilt 1995 · S/N LJ1389 N200UGRaw Logistics LLC · Bethel, NCBuilt 1978 · S/N E-1225 N200UWTrustees Of The University Of Wyoming · Laramie, WYBuilt 1983 · S/N BB-1155 N200VAVargus Group Inc · Providence, RIBuilt 1977 · S/N BB-246 N200WBTurbo Air Charter LLC · Boise, IDS/N BB-1754 N200WLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 352 N200WPIdplane LLC · Boise, IDBuilt 1991 · S/N BB-1393 N200WXMorales J Mark Trustee · Corpus Christi, TXBuilt 1979 · S/N BB-680 N200XCTvpx Ars Inc Trustee · North Salt Lake, UTS/N BB-1061 N200XLCondor Aviation LLC · Bethlehem, PABuilt 1981 · S/N 31T-8166010 N200ZZAirtrex Aircraft Charlie Inc · Wichita, KSBuilt 1979 · S/N BC-64 N2015CMorgan Arrow LLC · Greeley, COBuilt 1978 · S/N E-1311 N2016NOsfly LLC · Wilmington, DEBuilt 1978 · S/N E-1313 N2018ADiamond B Farms Trucking Inc · Gamaliel, KYBuilt 1978 · S/N E-1321 N2019ZTvat LLC · Sun City, AZS/N E-1322 N201GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-201 N201SUImp Inc · Coatesville, PANon-citizen corporation, flight hours not reportedBuilt 2001 · S/N 560-0586 N201WCC W Swift And Associates Inc · Sherman Oaks, CABuilt 1969 · S/N E-191 N2020QKaravan LLC · Gilford, NHBuilt 2020 · S/N 208B5610 N2021UAll Airline Pilot Training LLC · Delray Beach, FLBuilt 1978 · S/N TH-957 N2022NKauffman Jeffrey B · Leominster, MABuilt 1978 · S/N E-1334 N2022TAero-Marine LLC · Miramar Beach, FLBuilt 1978 · S/N TH-950 N2023CFulps Aviation LLC · Winston Salem, NCBuilt 1979 · S/N TH-1012 N2024QFoose John L Trustee · Sammamish, WABuilt 1978 · S/N E-1339 N2025NA B C Leasing Inc · Oakdale, LABuilt 1978 · S/N E-1336 N2026WGta Air Inc · Addison, TXBuilt 1978 · S/N TH-976 N2027DNichols Neil A · Aalachicola, FLBuilt 1978 · S/N TH-974 N2027UJpb Diversified LLC · Auburndale, FLBuilt 1978 · S/N TH-964 N20292Laflight LLC · Goldsboro, NCBuilt 1978 · S/N TH-966 N2029PTurnpoints LLC · Wilmington, DEBuilt 1978 · S/N E-1346 N202AASimply Living LLC · Fort Myers, FLBuilt 1980 · S/N 421C1015 N202AVAvista Corp · Spokane, WABuilt 1999 · S/N 650-7108 N202DKarschney Rich · Pateros, WABuilt 1947 · S/N D-57

Back to AD 2006-16-18 R1