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.

N511WMD&D Industries Inc · Monclova, OHBuilt 1973 · S/N LW-57 N511WSMcbride Aviation LLC · Longview, TXBuilt 1979 · S/N 501-0136 N5123Tpi Aircraft Interiors LLC · New Bern, NCBuilt 1984 · S/N 123 N5128CLacey Nora B Trustee · Incline Village, NVBuilt 2002 · S/N E-3455 N512ARTwin Otter International Ltd · Las Vegas, NVBuilt 1967 · S/N 59 N512ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 39043 N512DCRegistered aircraftBuilt 2002 · S/N FL-342 N512DHPlane6 LLC · Fort Lauderdale, FLBuilt 2016 · S/N 208B5324 N512EXTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 208B5934 N512JCCarr Air LLC · Cornelius, NCBuilt 2001 · S/N 258556 N512MEBridger Aerospace Group Holdings LLC · Belgrade, MTBuilt 1991 · S/N FL-61 N512WCCarr Air LLC · Cornelius, NCBuilt 2002 · S/N 258595 N5137BTextron Aviation Inc · Wichita, KSFirst renewal noticeBuilt 2007 · S/N E3547 N513ASUmb Bank Na Trustee · Salt Lake City, UTBuilt 2008 · S/N 35192 N513BEH800 IV LLC · Stuart, FLBuilt 2000 · S/N 258471 N513FSJackson Construction Services LLC · Wichita Falls, TXS/N 421C0510 N513JMBank Of Utah Trustee · Salt Lake City, UTBuilt 1991 · S/N LJ-1274 N513JNFly Area LLC · Charleston, SCS/N 421C0293 N513RV1551 Leasing LLC · Placida, FLBuilt 2003 · S/N 525-0513 N513SJWagner Distributing Co Inc · Auburn, CABuilt 1975 · S/N 421C0043 N513SKHappy Skies LLC · Dover, DEBuilt 2004 · S/N 338 N513TSGully Air LLC · College Station, TXBuilt 1999 · S/N 650-7096 N513WTL L Express LLC · Wilmington, DEBuilt 1987 · S/N 551-0556 N514ASAlaska Airlines Inc · Seattle, WABuilt 2008 · S/N 35193 N514BKNot For Naught LLC · Wimberley, TXBuilt 1974 · S/N E-514 N514CKKenvic Aviation LLC · De Armanville, ALBuilt 2021 · S/N 525-1096 N514DHAirprop Inc · Portsmouth, NHBuilt 2021 · S/N FL-1250 N514DSLugo Jose E Jr · Donna, TXBuilt 1998 · S/N 525-0255 N514JAAb Southwest Properties LLC · O Fallon, MOBuilt 2014 · S/N 525-0859 N514TBFast Marketing Strategies LLC · Royal Oak, MDBuilt 1990 · S/N BB-1351 N5150EM & M Aviation Enterprises LLC · Springfield, MOS/N E-3412 N515ARTwin Otter International Ltd · Las Vegas, NVBuilt 1976 · S/N 515 N515CYPacwest Aerodyne LLC · Tualatin, ORS/N 028 N515GKAvintel Management LLC · Dublin, OHBuilt 1974 · S/N LW-108 N515JMSmith Peter I Trustee · Ocala, FLBuilt 2024 · S/N 208B5827 N515MVJb Aircraft LLC · Anchorage, AKBuilt 2017 · S/N 208B5356 N515PEDog Is My Copilot Inc · Jackson, WYBuilt 2007 · S/N 208B1256 N515PPDog Is My Copilot Inc · Jackson, WYBuilt 2004 · S/N 208B1084 N515RGDowney Paul J · Newington, NHS/N TH-2108 N516ASWilmington Trust Co Trustee · Wilmington, DEBuilt 2008 · S/N 39044 N516CJTotal Aviation Corp · Garden City, NYBuilt 1980 · S/N 016 N516KGBrisket Express Aircraft Company LLC · Teton Village, WYBuilt 1977 · S/N 501-0023 N516KMPico Cellular Communications Inc · Key Largo, FLBuilt 2015 · S/N 525-0868 N516NCCobra Aviation Services LLC · Oklahoma City, OKBuilt 2008 · S/N 208B2070 N516PRDepartment Of Natural & Environmental Resources · San Juan, PRS/N 208B1053 N516THHippo Air LLC · Grants Pass, ORBuilt 1999 · S/N 258418 N517ASAlaska Airlines Inc · Seatac, WABuilt 2008 · S/N 35197 N517DJUrquhart Dan DBA · Fallon, NVBuilt 1997 · S/N E-3075 N517HAHarrison Aviation LLC · Macon, GABuilt 1984 · S/N E-2175 N517MHCbtm Aviation LLC · Leesburg, FLBuilt 1976 · S/N 421C0104

Back to AD 2006-16-18 R1