Registered aircraft · 40,473

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N658LMLge Flying Club Inc · Marietta, GABuilt 1973 · S/N 17261599 N658NVJp Aero Holdings Inc · Carson City, NVBuilt 1981 · S/N 17275439 N658RLVagim Jason P · Granbury, TXBuilt 2002 · S/N 81373 N658SEvalenko Robert A · Arlington, TNFirst renewal noticeBuilt 1997 · S/N 24037 N658SRJung Sue Elaine · Lawton, OKBuilt 1968 · S/N 17700976 N658VCruiser Flying LLC · Pleasant View, UTBuilt 2005 · S/N 2301 N658XLMertz George H III · Reading, PABuilt 1997 · S/N 17280096 N65909Oldwater Trailers Inc · Wilmington, DEBuilt 1983 · S/N 17275920 N6590AJ Robert Finley And Associates Inc · Mountain Home, ARBuilt 1983 · S/N M-2380 N6590JRegistration Pending · Rathdrum, IDRegistration pendingBuilt 1968 · S/N 28-5049 N6590PClyde Damon S · Boulder City, NVBuilt 1960 · S/N 24-1712 N6590USanchez John D · Columbiaville, MIBuilt 1962 · S/N 2372 N6591AHerk Aviation LLC · New Bern, NCBuilt 1983 · S/N M-2381 N6591EWay Robert Louis · Morristown, AZBuilt 1978 · S/N 17272041 N6591PRichardson Jeffrey S · Grove City, PABuilt 1960 · S/N 24-1713 N65923Noste Erik · Mount Vernon, WABuilt 1983 · S/N 17275923 N6592JWorland Flying Club LLC · Worland, WYBuilt 1968 · S/N 28-5052 N6592LPruszenski Stanley F · Anchorage, AKBuilt 1974 · S/N 18-7409109 N6592UEriksson Trent A · Waterford, MIBuilt 1962 · S/N 2374 N6592WChait Braeden Abraham · Vancouver, WAS/N 28-20681 N6593AHard Luck Aviation LLC · Tok, AKBuilt 1981 · S/N 18-8109028 N6593JRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1968 · S/N 28-5053 N6593PAshenhurst Thane T · Wheatland, WYBuilt 1960 · S/N 24-1715 N6593RZwicker Brian · Richmond Hill, GABuilt 1974 · S/N M-1602 N6594JHub City Aviation Academy LLC · Lubbock, TXBuilt 1968 · S/N 28-5054 N6594PBoyd Larry C · Wellton, AZBuilt 1960 · S/N 24-1716 N6594RBig Bend Community College · Moses Lake, WABuilt 1974 · S/N MB-718 N6595G95 Golf Inc · Greenwood, INBuilt 1980 · S/N 17273609 N6595KMr B Aviation LLC · Sag Harbor, NYBuilt 1948 · S/N 1 N6595RBig Bend Community College · Moses Lake, WABuilt 1974 · S/N MB-714 N6596DMcdonald Kevin K · Anchorage, AKBuilt 1979 · S/N 17272885 N6596ULipper Charles S Pers Rep · Stone Mountain, GAFirst renewal noticeBuilt 1962 · S/N 2378 N6596WN6596w LLC · Derby, KSBuilt 1965 · S/N 28-20686 N6596XRingen Marvin O · Beaverton, ORS/N 693 N6597GOff Airport Adventures LLC · Saint David, AZBuilt 1971 · S/N 15072097 N6597UAldo Leonardi · Woodland, CAS/N 2379 N6598JThatcher Bruce Lyall · Shorewood, MNBuilt 1968 · S/N 28-5057 N65994Christiansen Aviation LLC · Wilmington, DEBuilt 1983 · S/N 17275942 N6599DBlue Shield Aviation LLC · Saint Petersburg, FLBuilt 1979 · S/N 17272886 N6599JCormack Matthew S · Chandler, AZBuilt 1968 · S/N 28-5058 N659FLHudacko Daniel M · Saint Cloud, FLFirst renewal noticeS/N 28-7125577 N659HCHowlett Corey · Wasilla, AKS/N 1140-79 N659KWWoods Kevin E · Albrightsville, PABuilt 1974 · S/N 28-7415515 N65ATRhodes Steven D · Anchorage, AKBuilt 1981 · S/N 1016 N65BJRamage Calvin L · Columbia, MOBuilt 1994 · S/N 1 N65BMVolatilis LLC · Wilmington, DES/N VAC73-77 N65CDTeva Services LLC · Land O Lakes, FLS/N 60065 N65DPPilawski Darren · Spring Hill, FLS/N 17257299 N65EJRobbins Lesley Linn · Bend, ORBuilt 2003 · S/N 9959CC N65ESShaw Ellen M · Green Bay, WIBuilt 1998 · S/N 324R

Back to AD 80-04-03 R2