Registered aircraft · 1,827

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:90-06-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13') 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:90-06-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13')
  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:90-06-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-06-13')
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.

N131SJGravitas Aviation LLC · Dallas, TXBuilt 1976 · S/N BB-131 N132CESouthern Energy Transport LLC · Shelbyville, TNBuilt 1995 · S/N 650-7061 N135MKRio Frio Leasing Co LLC · Houston, TXBuilt 1984 · S/N FA-3 N135WCSdac Air LLC · Selma, ALBuilt 1994 · S/N 5600261 N137JCBcaf LLC · Indialantic, FLBuilt 1991 · S/N 560-0137 N138CAPresidio Citation Bravo LLC · Chicago, ILBuilt 1999 · S/N 550-0900 N139RNIsland Air Operations LLC · Wilmington, DEBuilt 1999 · S/N 550-0886 N139RRRyan Renae L Trustee · Wichita, KSBuilt 1976 · S/N BB-177 N13CRPreferred Aviation LLC · Fayetteville, ARS/N 560-0056 N1400MGainesville Aircraft Sales Inc · Gainesville, FLS/N 650-0140 N140TSInch & Co Aviation LLC · York, PAS/N 650-0141 N140WHVarney Aviation LLC · Bangor, MEBuilt 1991 · S/N 650-0195 N141SMInfinity Aeronautics LLC · Greer, SCBuilt 1984 · S/N FA-23 N143DEAac 585 LLC · Kennesaw, GABuilt 1979 · S/N BB-585 N144CAKingdom Heir Aviation LLC · Frisco, TXBuilt 1992 · S/N 650-7004 N144KMKcc Av LLC · Fayetteville, ARBuilt 2001 · S/N 560-0579 N144ZVN129rp LLC · Tulsa, OKBuilt 2000 · S/N 550-0926 N145KKDodson International Parts Inc · Rantoul, KSBuilt 1994 · S/N 560-0276 N149CCCianbro Corp · Baltimore, MDS/N FA-145 N149HC149hc LLC · Bend, ORBuilt 1999 · S/N 550-0898 N14RM29foxtrot LLC · Wilmington, DEBuilt 1980 · S/N 551-0169 N150GPSteel Aircraft Leasing LLC · Saint Augustine, FLFirst renewal noticeS/N 560-0127 N151ELCarolina Turbine Sales Inc · Raleigh, NCBuilt 1978 · S/N BB-371 N152JHSeaport Aviation Inc · Quincy, MABuilt 2002 · S/N 560-0615 N152WLHeart One LLC · Little Rock, ARBuilt 1977 · S/N BB-260 N153TN153t LLC · Kalispell, MTS/N 550-0732 N154JKRacd Holding LLC · Pembroke Pines, FLBuilt 1991 · S/N 560-0128 N155PTWaypoint Aviation LLC · Wilmington, DEBuilt 1994 · S/N 560-0257 N156GWM-W Air Lc · Horseshoe Bay, TXBuilt 2001 · S/N 550-0982 N157TFMeyers Aircraft Trading West LLC · Windermere, FLBuilt 1991 · S/N 560-0157 N158JSMae Aviation LLC · Dover, DEBuilt 2000 · S/N 560-0540 N15JTSignalwave LLC · Ocala, FLBuilt 1989 · S/N 560-0015 N15KALighthouse Air LLC · Hobe Sound, FLBuilt 1979 · S/N BB-457 N15RNExecutive Jet A LLC · Danbury, CTBuilt 1999 · S/N 560-0520 N15SLCp Ultra LLC · Sacramento, CABuilt 1994 · S/N 560-0272 N15WTJet Amigos LLC · Central Point, ORBuilt 1982 · S/N 550-0423 N160SFTriumph Aviation LLC · Gaylord, MIBuilt 1975 · S/N BB-32 N161SDSierra Delta Aviation LLC · Boise, IDBuilt 1996 · S/N 650-7066 N161TMHudson Air LLC · Hudson, OHBuilt 1999 · S/N 550-0867 N162TJMcm Jet LLC · Mooresville, NCBuilt 1999 · S/N 550-0888 N163BALbk Air LLC · Newark, DEBuilt 1984 · S/N FA-18 N163JN163j LLC · Smithfield, NCBuilt 1987 · S/N S550-0122 N163JMGainesville Aircraft Sales Inc · Gainesville, FLBuilt 1988 · S/N 650-0163 N164RAJetway N164 LLC · Brooklyn, OHBuilt 2007 · S/N 560-0766 N166BASmith Joshua B · Kenai, AKBuilt 1988 · S/N FA-147 N166SAClear Skies Ltd · Cincinnati, OHBuilt 1988 · S/N FA-166 N166STGable S Corp · West Linn, ORBuilt 2002 · S/N 560-0606 N168BGValle Aviation Inc · Nashville, GABuilt 1995 · S/N 5600301 N168ESNext Generation Aviation LLC · Beloit, WIBuilt 1992 · S/N 550-0706 N169CRContinental Resources Inc · Baker, MTBuilt 2026 · S/N 560-6506

Back to AD 90-06-13