OpenAirDocs.org
AD 2001-08-13

Registered aircraft · 606

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
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:2001-08-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:2001-08-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.

N889CGPrima Air LLC · Pasadena, CABuilt 1999 · S/N 1386N889KHInnova Aviation LLC · Pasadena, CABuilt 1998 · S/N 540N892QMMedina Iran · North Bay Village, FLS/N 078N898Rare Air Aviation Services LLC · Santa Rosa, CABuilt 2005 · S/N 4019N899ALGulfstream Givsp 1495 LLC · East Hampton, NYBuilt 2002 · S/N 1495N900LY6500 LLC · Pittsfield, MABuilt 2001 · S/N 661N900WRReaud Wayne A · Santa Fe, NMBuilt 2000 · S/N 1416N905LPChateau Aviation LLC · Wilmington, DEBuilt 1997 · S/N 1321N908JTValiair Lc Trustee · Casper, WYBuilt 1990 · S/N 1145N90JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 552N90RGRobtoria Aircraft Leasing LLC · Wilmington, DEBuilt 2000 · S/N 1410N9102Tvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 551N910AFAfh Aviation LLC · Mineola, NYBuilt 1997 · S/N 1312N913SPLockton Enterprises Inc · Kansas City, MOBuilt 1997 · S/N 516N915BDDillards Inc · Little Rock, ARBuilt 2002 · S/N 690N917MS917ms LLC · Longwood, FLBuilt 1994 · S/N 1241N917WMetro Helicopter LLC · Los Angeles, CABuilt 1991 · S/N 1158N918SCCharlie November One LLC · Sheridan, WYBuilt 1988 · S/N 1075N91JSReserve Aircrafts LLC · New York, NYBuilt 2002 · S/N 1485N924MBEvolution Development Partners LLC · Beverly Hills, CABuilt 1987 · S/N 1023N925DCAvion LLC · Birmingham, ALBuilt 1995 · S/N 1279N926TTSn 1372 LLC · Wilmington, DEBuilt 1999 · S/N 1372N927JASn5028 LLC · Hollywood, FLBuilt 2000 · S/N 1426N92BSS&E Aviation LLC · Birmingham, MIBuilt 2003 · S/N 1502N930LSSadie Aviation LLC · Houston, TXBuilt 1999 · S/N 580N934HEJemb Gv LLC · New York, NYBuilt 1999 · S/N 564N935RWelcome Grove LLC · West Sacramento, CABuilt 2000 · S/N 1405N936AM936am LLC · Mount Pleasant, SCBuilt 2002 · S/N 1488N939PGUrnxtjet LLC · Deland, FLBuilt 1993 · S/N 1212N945PKArchangel Operations LLC · Lewes, DEBuilt 1975 · S/N 165N945XCStratton Ventures LLC · Dover, DES/N 1019N946NANational Aeronautics And Space Administration · Houston, TXBuilt 1974 · S/N 146N955MBHms Air LLC · Van Nuys, CABuilt 1987 · S/N 1022N956JMJam Aviation LLC · Laredo, TXBuilt 1993 · S/N 1223N958BXGulfstream 1227 LLC · Lewes, DEBuilt 1993 · S/N 1227N95NAN.A.S.A Lyndon B Johnson Space Center · Houston, TXS/N 672N960JSJordgrant1521 LLC · Santa Monica, CABuilt 2004 · S/N 1521N960LSNewport Executive Transportation Inc · Las Vegas, NVBuilt 1990 · S/N 1135N962MMM A R Aviation Sn204 LLC · Latrobe, PABuilt 2000 · S/N 605N970BGProfessional Building Systems Inc · Middleburg, PABuilt 1998 · S/N 562N972MSGlf4 1285 LLC · Raleigh, NCBuilt 1996 · S/N 1285N975RGRg Aviation LLC · Fort Lauderdale, FLS/N 471N978CCSurfnturf Rec Holdings LLC · Camden, DES/N 1335N984JWNinety Eight Aviation LLC · Fort Myers, FLFirst renewal noticeBuilt 1989 · S/N 1091N98LT98lt LLC · Austin, TXBuilt 1995 · S/N 1278N992NANational Aeronautics And Space Administration · Houston, TXBuilt 1980 · S/N 309N995GGAerovision Aircraft Holdings Inc · Dover, DEBuilt 1988 · S/N 1074N996GAAb Jet Co IV LLC · Metairie, LABuilt 2000 · S/N 596N998GPAir Mccormack2 LLC · Chicago, ILBuilt 1988 · S/N 1061N999AASuperior Transportation Associates Inc · Costa Mesa, CABuilt 1996 · S/N 1286
Back to AD 2001-08-13