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.

N536AMTriniair LLC · Warner Robins, GABuilt 1978 · S/N E1172 N536ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 35203 N536BAPlasko Enterprises LLC · Trumbull, CTBuilt 1978 · S/N E-1170 N536BCChavers Construction Inc · Cantonment, FLS/N E-2160 N536EUSarabay Aviation Partners LLC · Sarasota, FLBuilt 2005 · S/N E-3616 N536KEngage Helicopters LLC · Sarasota, FLS/N E3220 N536PSky High II LLC · Clinton, NCBuilt 1998 · S/N E3197 N536WWright Jack · Fortson, GABuilt 2002 · S/N E-3458 N537ARAvro Ltd · Las Vegas, NVBuilt 1977 · S/N 537 N537ASAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 35204 N537CAAc Spe 10 LLC · Orlando, FLBuilt 2004 · S/N 33749 N537SWBingham Leasing Co Lc · Mesa, AZBuilt 1991 · S/N TH-1619 N538ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 41188 N538ATAirtrex Registration Corp Trustee · Wichita, KSS/N FL-736 N539ATAirtrex Registration Corp Trustee · Wichita, KSS/N FL-834 N539JMN539jm LLC · Clovis, NMBuilt 1995 · S/N 560-0339 N539REdward Jennings LLC · Valdosta, GABuilt 1985 · S/N E-2296 N539SATvpx Aircraft Solution Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 208B5822 N53APLta Group Holdings LLC · Amarillo, TXS/N LJ-1700 N53ARGuardian Flight LLC · Lewisville, TXBuilt 1998 · S/N BB-1629 N53BAIvester Drywall & Painting Inc · Salisbury, NCBuilt 1979 · S/N BB-426 N53CEEngineering And Mfg Svcs Inc · Huntsville, ALBuilt 1975 · S/N LW-160 N53CVExecutive Air Taxi Corp · Bismarck, NDS/N FL101 N53ECBas Part Sales LLC · Greeley, COBuilt 1972 · S/N LJ552 N53GA52 Whiskey LLC · Elkhart, INBuilt 1985 · S/N BB-1201 N53HAInky Aviation LLC · Sellersburg, INFirst renewal noticeBuilt 1997 · S/N 650-7076 N53HJVentura Aviation Inc · Farmingdale, NYBuilt 1982 · S/N 037 N53HSC&B Aerial Transport Inc · Wilmington, DEBuilt 1976 · S/N LW-186 N53KADesert Mountain Air LLC · Kalispell, MTBuilt 1981 · S/N BB-880 N53KGKentucky State Police · Frankfort, KYBuilt 2021 · S/N FL-1246 N53KVBank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 525-0030 N53KWWiley Bob Inc Trustee · Troy, ALS/N 028 N53LEBonanza With A Cause LLC · Westlake Village, CAS/N E-3488 N53LPN53lp LLC · Amarillo, TXBuilt 1996 · S/N 560-0375 N53MG28 Lv LLC · Las Vegas, NVBuilt 1980 · S/N 421C0909 N53MJAviation Hangar Foam Specialists LLC · Tucson, AZBuilt 1979 · S/N 421C0667 N53PE3cap Aviation LLC · Scottsdale, AZBuilt 1998 · S/N 560-0464 N53RTCas Capital Holdings LLC · Newark, DES/N TH-2113 N53SMClayton Leasing Inc · Aberdeen, MSBuilt 1996 · S/N 560-0353 N53STBlue Link LLC · Bay City, WIBuilt 2002 · S/N 560-0624 N53TEThumb Aviation LLC · Bad Axe, MIBuilt 2017 · S/N 208B5351 N53TJNion LLC · New Century, KSBuilt 1989 · S/N LJ-1209 N53UPhenphilo3 LLC · Wilmington, DEBuilt 2000 · S/N 208B0855 N53WWPlanemarketing LLC · Vero Beach, FLS/N E-3480 N54Textron Aviation Inc · Wichita, KSS/N FL-1383 N540CASpradlin Flying Service Inc · Petersburg, TXBuilt 1976 · S/N 421C-0144 N540CCAndriopulos Salguero Inc · Hialeah, FLS/N 421C0675 N540EALastra Air Cargo Express · Saint Petersburg, FLS/N 174 N540JLBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 525-1138 N540KTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2005 · S/N 258702

Back to AD 2006-16-18 R1