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.

N671KWKwik Wall 1 LLC · Springfield, ILBuilt 1998 · S/N 5250273 N672JMPeregrine Aviation LLC · Tallahassee, FLBuilt 2002 · S/N 525-0485 N674GSale Reported · Marana, AZSale reportedS/N 550-0435 N674NDDodson International Parts Inc · Rantoul, KSS/N 550-0852 N675SSStructural Steel Services Inc · Meridian, MSBuilt 2006 · S/N 550-1123 N676CMMike Mike LLC · Wilmington, DEBuilt 1980 · S/N 550-0186 N676GHNoll Air LLC · Orlando, FLBuilt 2004 · S/N 258676 N676RAJet Air Inc · Iowa City, IABuilt 1999 · S/N 550-0876 N678GSMeisner Aircraft Inc · Burlington, WIBuilt 1992 · S/N 5500710 N678RTWorld Is Not Enough LLC · Turner, ORBuilt 1999 · S/N 525-0304 N67AZLazy Ta Legend Aircraft LLC · Wilmington, DEBuilt 1998 · S/N 525-0245 N67BDVerde Aviation LLC · Medina, WABuilt 1995 · S/N 560-0313 N67BEPonderosa Aviation LLC · Safford, AZBuilt 1989 · S/N 550-0619 N67BKSdkt Properties LLC · Salinas, CABuilt 2002 · S/N 550-0997 N67JBHap Ventures LLC · Mukilteo, WABuilt 2001 · S/N 550-0980 N67JTIntermountain Powersports Inc · Salt Lake City, UTBuilt 2001 · S/N 525-0469 N67MTWindway Capital Corp · Sheboygan Falls, WIBuilt 1996 · S/N 254 N67SFDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 5500243 N680JSBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 349 N681JZDanco Builders · Arcata, CABuilt 2004 · S/N 560-0681 N681SCLfg Aviation Holdings LLC · Kalispell, MTBuilt 2000 · S/N 258502 N682DGDpr Group LLC · Marshall, TXBuilt 2004 · S/N 560-0673 N684PSMedical Air Inc · Raleigh, NCBuilt 2016 · S/N 525-0932 N686JHHorton Aviation LLC · Tulsa, OKBuilt 2013 · S/N 525-0810 N686RCNevada Holdings LLC · Wetumpka, ALBuilt 1982 · S/N 550-0438 N686TXYour Jet LLC · Wilmington, DEBuilt 2004 · S/N 258686 N689VPN689vp LLC · Pasadena, TXBuilt 1991 · S/N 550-0689 N68CBCracker Barrel Old Country Store Inc · Lebanon, TNBuilt 1999 · S/N 258453 N68CHIntentional Air LLC · Brigham City, UTBuilt 2016 · S/N 525-0902 N68KKC&J Aviationllc · Wichita, KSBuilt 2017 · S/N 525-0945 N68YBCzzc Aviation LLC · Tucson, AZBuilt 1999 · S/N 290 N690ESInternational Aviation Sales Ltd · Cleveland, OHBuilt 1995 · S/N 560-0336 N691DCNorthern Meridian LLC · Fargo, NDBuilt 1998 · S/N 560-0489 N691ESInternational Aviation Sales Ltd · Cleveland, OHBuilt 1997 · S/N 560-0402 N691TWSage Holdings LLC · Woodward, OKBuilt 2005 · S/N 560-0691 N693BBBurrows Robert · Newton, WIBuilt 2026 · S/N 525-1410 N694ESMonfort Aviation LLC · Eaton, COBuilt 2004 · S/N 258694 N695AKAlascom Inc · Anchorage, AKBuilt 2005 · S/N 560-0695 N695PAPafford Air Of Mississippi LLC · Ruston, LABuilt 1996 · S/N 525-0158 N695TAM & B Holdings Of Delaware LLC · Lewes, DEBuilt 1979 · S/N 550-0374 N696RGPecos Bend Royalties Lllp · Midland, TXBuilt 1997 · S/N 265 N696RQAzul Aviation Inc · Burleson, TXS/N 311 N696VPRegistered aircraftBuilt 1991 · S/N 550-0696 N697USAlanis Armando Jr · Mcallen, TXBuilt 1980 · S/N 465-49 N699CJSra/Rombert Aviation LLC · Miami Beach, FLBuilt 2010 · S/N 525-0699 N6FJFlying Farmer LLC · Wilmington, DEBuilt 1977 · S/N 97 N6HFWestern Community College Area · Scottsbluff, NES/N 550-0260 N6NCMeadowbrook Holdings LLC · Novi, MIBuilt 1997 · S/N 525-0217 N6NRSdi Aviation LLC · Rhinelander, WIBuilt 2004 · S/N 258701 N6TRJmr Aviation LLC · Midland, TXBuilt 2001 · S/N 560-0573

Back to AD 97-05-03 R1