Registered aircraft · 2,862

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:97-05-03-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:97-05-03-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:97-05-03-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:97-05-03-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:97-05-03-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:97-05-03-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.

N883MTFlywheel LLC · Austin, TXBuilt 2015 · S/N 525-0883 N883TXWhitehorse LLC · Puyallup, WABuilt 2008 · S/N 560-0784 N8844Diamond And A Half Cattle Company LLC · Lake Havasu City, AZS/N 525-0254 N884RCJannenga Air LLC · Phoenix, AZBuilt 2001 · S/N 560-0552 N885JHO & H Air LLC · Paris, TXBuilt 2021 · S/N 525-1098 N886YSTs Sky LLC · Sellersburg, INBuilt 2002 · S/N 550-1013 N887SBGosmartair LLC · Harrisburg, PABuilt 2015 · S/N 525-0887 N888FGTv Brothers LLC · Houston, TXBuilt 1981 · S/N 550-0298 N888GDCluheir LLC · Van, TXBuilt 2002 · S/N 560-0634 N888LSLadd Sanger · Saratoga, WYBuilt 2020 · S/N 525-1048 N888RAHope Air LLC · Lewes, DES/N 525-0135 N888RLRegistered aircraftBuilt 1981 · S/N 550-0254 N888UPTeam Aero LLC · Shawnee, KSBuilt 1981 · S/N 465-68 N888WDEagles Wings Holdings II LLC · Canfield, OHBuilt 2004 · S/N 550-1097 N888WEPrime Aircraft & Aviation LLC · Edmond, OKS/N 394 N888XLStafford Mark K · Prineville, ORBuilt 1989 · S/N 5500598 N889AVAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 2002 · S/N 258581 N889CP1khomes LLC · Asheville, NCBuilt 1978 · S/N 550-0031 N889TAPrivate Flight II LLC · Oklahoma City, OKBuilt 2014 · S/N 525-0823 N88ADN88ad Leasing LLC · Jackson, TNBuilt 2000 · S/N 525-0404 N88AJMarathon Merchant LLC · Waukesha, WIBuilt 1999 · S/N 550-0885 N88LSPrince George Aviation LLC · Memphis, TNBuilt 2001 · S/N 525-0475 N890BA818 Operations Inc · Wilmington, DES/N 301 N890LJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N 487 N890MTRauch Richard B · Wilsonville, ORBuilt 2015 · S/N 525-0890 N891FVSuper King LLC · Wilmington, DEBuilt 1997 · S/N 560-0427 N891KSParr Aviation LLC · Demopolis, ALBuilt 1993 · S/N 560-0210 N892QMMedina Iran · North Bay Village, FLS/N 078 N892TXByte Me Transportation Inc · Fort Pierce, FLBuilt 2002 · S/N 258592 N894NTTeam Aero LLC · Olathe, KSS/N 550-0827 N894TWD Jm Holdings LLC · Sugar Land, TXBuilt 1981 · S/N 354 N896CGJet Services Inc · Mobile, ALBuilt 2003 · S/N 550-1055 N896MAQ-Sky LLC · Fairhope, ALBuilt 2003 · S/N 550-1065 N896TWShineair LLC · Collierville, TNBuilt 2015 · S/N 525-0894 N896VRTetra Trvl LLC · La Mirada, CABuilt 2003 · S/N 258640 N897ACoastal Greens Aviation LLC · Myrtle Beach, SCBuilt 1997 · S/N 258326 N897MDDodson Building Group LLC · Kalispell, MTBuilt 2019 · S/N 525-1035 N898GTKevoop Holdings LLC · El Dorado Hills, CABuilt 2020 · S/N 525-1059 N898LGGold Penny Aviation LLC · Stayton, ORBuilt 2004 · S/N 550-1080 N898SLMurphy Air LLC · Pine Bluff, ARBuilt 2000 · S/N 550-0902 N899BEcho Romeo Aviation LLC · Dallas, TXBuilt 2003 · S/N 5501073 N899PEArkansas Jet Sales & Leasing LLC · Little Rock, ARBuilt 1994 · S/N 560-0252 N89DSowela Technical Community College · Lake Charles, LABuilt 1979 · S/N 550-0056 N89GAWno Trust Services LLC Trustee · Wilmington, DES/N 550-0122 N89MDFuturesource Capital Corp · Bismarck, NDBuilt 2002 · S/N 560-0612 N89PR603 Holdings LLC · Aberdeen, SDBuilt 2002 · S/N 560-0603 N89TBAir Med Capital LLC · Kissimmee, FLBuilt 1979 · S/N 272 N89WABurris D Rob Trustee · Tucson, AZBuilt 1999 · S/N 258420 N8EBWoodbine Aviation LLC · Lewes, DEBuilt 1981 · S/N 550-0280 N8LTAviation Enterprises Inc · Marietta, GABuilt 1980 · S/N 173

Back to AD 97-05-03 R1