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.

N800UWUniform Whiskey Holdings LLC · Opa Locka, FLBuilt 1998 · S/N 258395 N800WFVarsity Aviation LLC · Martinsburg, PABuilt 2005 · S/N 258728 N800WTBode Aviation Inc · Albuquerque, NMBuilt 1998 · S/N 5500859 N800WWPnw Transport LLC · Tucson, AZBuilt 2004 · S/N 258661 N800XMFlyteme Aviation LLC · Fort Pierce, FLBuilt 1999 · S/N 258414 N800XRSparks Aviation Ownership LLC · Santa Rosa Beach, FLBuilt 1995 · S/N 258283 N801CBBaugh Aviation Services LLC · Orem, UTBuilt 2001 · S/N 560-0584 N802CAThree Thirty Three LLC · Collierville, TNBuilt 2002 · S/N 550-1034 N802CFLitton Global LLC · Wilmington, DEBuilt 1999 · S/N 258425 N803NLN803nl LLC · Forest, VABuilt 1998 · S/N 273 N803SCStrom Law Firm LLC · Columbia, SCBuilt 1995 · S/N 560-0287 N80404Hart Aviation LLC · Emory, TXS/N D-4 N80406Johnson Raymond · Eldridge, NDBuilt 1947 · S/N D-6 N80409Beechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1947 · S/N D-9 N80411Parkin Steven H · Yucca Valley, CAS/N D-11 N80412Nason David F · Kent, WABuilt 1947 · S/N D-12 N80418Beechcraft Heritage Museum Inc · Tullahoma, TNBuilt 1947 · S/N D-18 N80423N80423 LLC · Palisade, COS/N D-23 N80429Cary William R · Graniteville, SCBuilt 1947 · S/N D29 N80431Biggs Aircraft Inc · Wellston, OKBuilt 1947 · S/N D-31 N80435Christopher T Hoke · Edmond, OKBuilt 1947 · S/N D-35 N80438Newhard Glenn K · Bethlehem, PABuilt 1947 · S/N D-38 N80444Furmanski Stan · Encino, CAFirst renewal noticeBuilt 1947 · S/N D-44 N80445Cromley Russell B · Odessa, FLBuilt 1947 · S/N D-45 N80465Right Coast Ventures LLC · Royse City, TXBuilt 1947 · S/N D-65 N804BHMahaska Bottling Co · Oskaloosa, IABuilt 2002 · S/N 258596 N804CCPappas John · Cave Junction, ORBuilt 1980 · S/N 305 N804CVPlastic Ingenuity Inc · Cross Plains, WIBuilt 2008 · S/N 5600804 N804JMStarr Aviation Solutions LLC · New York, NYBuilt 2000 · S/N 258467 N804MC824 Holdco LLC · Salt Lake City, UTBuilt 2004 · S/N 258684 N804NANasa Neil A Armstrong Flight Research Center · Edwards, CAFirst renewal noticeBuilt 1982 · S/N 344 N804RDLonestar Aviation LLC · Kalispell, MTBuilt 1993 · S/N 560-0220 N804TBN804tb III LLC · Stuart, FLBuilt 1999 · S/N 258438 N804TFRoyal Air Freight Inc · Waterford, MIBuilt 1981 · S/N 404 N805CJIcbs Aviation LLC · Allen, TXBuilt 2005 · S/N 525-0603 N805LCW Brown Enterprises Inc · Durant, OKBuilt 1988 · S/N 550-0581 N805PN805p LLC · Greenwood Village, COBuilt 2011 · S/N 525-0701 N805VCPhillips Air Ventures LLC · Tulsa, OKBuilt 1994 · S/N 525-0076 N806CM806 Assets LLC · Horseshoe Bay, TXS/N 525-0875 N806GJPb Air LLC · Higley, AZBuilt 2002 · S/N 258602 N806MNJm Soar LLC · Paradise Valley, AZBuilt 2003 · S/N 258605 N806TCAviation Resource Group Inc · Fort Lauderdale, FLS/N 258364 N807AVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 258597 N807BFSale Reported · Bishop, CASale reportedBuilt 1976 · S/N 194 N807BWTejama LLC · Amarillo, TXBuilt 2003 · S/N 560-0640 N807JCGwu LLC · Saint James, MOBuilt 2002 · S/N 560-0602 N807MBJ&P Aviation LLC · Jasper, ALS/N 550-0694 N808ACInterwings Aircharter Corp · Lewes, DEBuilt 1995 · S/N 560-0323 N808CEOpen Air LLC · Glendale, AZBuilt 2009 · S/N 560-0808 N808MCLrt Aero Partners LLC · Sheridan, WYBuilt 2003 · S/N 258614

Back to AD 97-05-03 R1