Registered aircraft · 11,797

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.

N968ABN968ab LLC · Southfield, MIBuilt 1997 · S/N 258315 N968ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30095 N968DBJustair LLC · Elkhorn, NEBuilt 1988 · S/N LJ-1172 N968FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0090 N968NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33241 N968PBank Of Utah Trustee · Salt Lake City, UTS/N E-3464 N968SRChrysler Aviation Inc · Van Nuys, CAS/N 560-0414 N968TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 20800513 N968TXTexas Department Of Public Safety · Austin, TXBuilt 2024 · S/N 20800713 N9693ACavu LLC · Honolulu, HIBuilt 1991 · S/N TH-1627 N9697FWilderness Aircraft III LLC · Boise, IDBuilt 1988 · S/N 20800128 N969ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 29546 N969FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0092 N969HLKing Fisher Air Services Air Safari Inc · San Juan, PRBuilt 2025 · S/N 208B5915 N969MAVenable Group LLC · Tupelo, MSBuilt 1981 · S/N BB-894 N969MCMec International Trading LLC · Daytona Beach, FLBuilt 1999 · S/N 208B0765 N969NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31215 N969PAdams Dirk L · Pleasant Hill, OHBuilt 1947 · S/N D-71 N969PLUS Government · Washington, DCBuilt 2005 · S/N 208B1119 N969TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 20800532 N969YKarika Thomas · Merritt Island, FLBuilt 1972 · S/N E-322 N96AMTexas A&M University System · College Station, TXBuilt 2000 · S/N BB-1713 N96BDRoberts Aircraft Inc · West Chicago, ILBuilt 1974 · S/N TH457 N96BLBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 560-0342 N96BMKm Medico LLC · Murrieta, CABuilt 1986 · S/N E-2297 N96CESummit Air Leasing LLC · Portage, MIBuilt 1996 · S/N BB-1536 N96DWTom Wood Aviation Inc · Fishers, INBuilt 1977 · S/N E-1197 N96GBEagle Equity Inc · Valparaiso, INS/N TH-882 N96HPCzachor Richard J · Sun City Center, FLBuilt 1975 · S/N E-723 N96JEAir Jody LLC · Riviera Beach, FLS/N LJ-1677 N96JKKdk Aviation Ltd · Findlay, OHBuilt 1997 · S/N E-3132 N96JTMarklyn Jet Parts LLC · Dallas, TXS/N 650-7014 N96KKPro Serve Aviation LLC · Englewood, COBuilt 1980 · S/N LA104 N96PSZsp Aviation LLC · Crestview, FLBuilt 1978 · S/N E-1426 N96PZDwd Aviation LLC · Jacksonville, FLBuilt 2016 · S/N 525-0938 N96TTTelcom Rentals LLC · Lake Charles, LAFirst renewal noticeBuilt 1980 · S/N LA-26 N96VWWheatcroft Andrew D · Dallas, TXS/N E-1189 N96WCUp And Down Aviation LLC · Carrollton, TXBuilt 1981 · S/N BB-969 N96WEChase Aviation De LLC · Dover, DEBuilt 1996 · S/N TH-1782 N96WFBrockman Leland Jay · Horseshoe Bay, TXBuilt 1990 · S/N TH-1595 N970ANAmerican Airlines Inc · Fort Worth, TXBuilt 2001 · S/N 30096 N970FEFederal Express Corporation · Memphis, TNBuilt 1988 · S/N 208B0093 N970GCAurora Skies LLC · Fernandina Beach, FLBuilt 1981 · S/N TH-1313 N970GWLaguera Construction Inc · Wilmington, DEBuilt 1983 · S/N 6500019 N970JMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N LJ-1650 N970KRJetx Aviation LLC · New Bern, NCBuilt 1979 · S/N BB-454 N970MMRegistered aircraftBuilt 2026 · S/N 525-1416 N970NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31218 N970STNational Nuclear Security Administration · Albuquerque, NMBuilt 2008 · S/N 29645 N971AMHoefler Wayne F · Colorado Springs, COBuilt 1981 · S/N LJ-983

Back to AD 2006-16-18 R1