Registered aircraft · 2,860

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.

N474CFCarrousel Aviation LLC · Monroe, WIBuilt 2004 · S/N 258662 N474KAIce9 Lear35 LLC · Boulder, COBuilt 1978 · S/N 174 N474NANeptune Aviation Services Inc · Missoula, MTS/N E2084 N474PECarolina Jet Partners LLC · Greenville, SCBuilt 1998 · S/N 560-0474 N475BVinyard Robert L Jr · Borger, TXBuilt 1948 · S/N D-1493 N475HCPj Company LLC · New Braunfels, TXBuilt 1983 · S/N 550-0475 N475HMFalcon Double D 163 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258451 N475RSRomeo Sierra LLC · Morgantown, WVBuilt 2004 · S/N 258674 N476RSK & M Industrial LLC · Gladstone, MIBuilt 1982 · S/N 550-0441 N477NANeptune Aviation Services · Missoula, MTBuilt 1988 · S/N E2103 N478NANeptune Aviation Services Inc · Missoula, MTBuilt 1987 · S/N E2074 N478VTTipnes Aviation LLC · Tampa, FLBuilt 1981 · S/N 308 N479CJLima Alpha One LLC · Newark, DEBuilt 2005 · S/N 525-0556 N479MYMcclain Mcclain Mcclain Inc · Ridgeland, MSBuilt 1993 · S/N 525-0018 N479RAValiair Limited Company Trustee · Casper, WYBuilt 2024 · S/N 525-1175 N47BFBoxley Farrell Aviation LLC · Roanoke, VABuilt 2024 · S/N 525-1171 N47HAHoosier Jets LLC · Sellersburg, INBuilt 1995 · S/N 258280 N47LLSmith Roy H · Garberville, CABuilt 1947 · S/N D-972 N47MFMed Flight Air Ambulance Inc · Albuquerque, NMBuilt 1982 · S/N 495 N47NMMooch Aire LLC · Anchorage, AKBuilt 2005 · S/N 550-1112 N47PWWelkin Aviation LLC · Beaver, WVBuilt 1992 · S/N 560-0186 N47RARoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 352 N47RBHolley Jack F · Morehead, KYS/N D-368 N47SEHighlands Group LLC · Lahaina, HIS/N 465-34 N47SHGc Aviation Investments LLC · Augusta, ARBuilt 1993 · S/N 525-0017 N47VBTautology Ltd · Longmont, COS/N D-936 N47VTBoyes Brothers Partnership · Benton City, MOBuilt 1947 · S/N D-730 N47WAHughston Chris · Brentwood, TNBuilt 1947 · S/N D-155 N480RLBaseload Realty LLC · Corpus Christi, TXBuilt 1991 · S/N 560-0109 N481NSJp Flying LLC · Dover, DEBuilt 1982 · S/N 378 N482EAWichita State University · Wichita, KSS/N 525-0482 N484AGBuckhorn Draw LLC · San Angelo, TXBuilt 2014 · S/N 525-0833 N484JSouthern Airways LLC · Ridgeland, MSBuilt 1994 · S/N 525-0048 N484MMN484mm LLC · Amarillo, TXBuilt 1998 · S/N 560-0491 N484SERoberts Steve C · Richmond, TXBuilt 2007 · S/N 525-0657 N486CCFlint Transport LLC · Albany, GABuilt 1997 · S/N 525-0213 N487CBCottingham & Butler Insurance Services Inc · Dubuque, IABuilt 2015 · S/N 525-0878 N488AMByte Me Transportation Inc · Fort Pierce, FLBuilt 2003 · S/N 258648 N488SBJ&P Aviation LLC · Jasper, ALS/N 550-1026 N488SRHard Way LLC · Dover, DEBuilt 2002 · S/N 525-0488 N489BMEd Santos & Associates LLC Trustee · Wilmington, DEBuilt 1994 · S/N 258271 N489CBAir Giant LLC · Watsonville, CABuilt 2002 · S/N 525-0489 N489HCJ C Cheek Contractors Inc · Kosciusko, MSBuilt 2001 · S/N 525-0437 N48DDRedstar Air Shows Inc · Discovery Bay, CABuilt 1979 · S/N 306146 N48DRRonald L Anderson LLC · Amery, WIBuilt 1998 · S/N 525-0272 N48FWLucas Oil Products DBA Lucas Cattle Co · Indianapolis, INBuilt 2000 · S/N 550-0948 N48JBN48jb LLC · Imperial, MOBuilt 1948 · S/N D-1371 N48KHAirshair LLC · Oak Creek, WIBuilt 1981 · S/N 550-0295 N492AN492a LLC · Gilbert, AZBuilt 1984 · S/N 425 N492CGSwan Aviation LLC · Hattiesburg, MSBuilt 1995 · S/N 560-0308

Back to AD 97-05-03 R1