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.

N64SSGriffiths Jon · Carson City, NVBuilt 1975 · S/N 17265345 N64THRaincross Aviation Services Inc · Wilmington, DES/N 22619 N64TLWadsworth Harley C · Albuquerque, NMBuilt 2000 · S/N 21180 N64TSLippincott George T · Thermopolis, WYBuilt 1981 · S/N 172RG0959 N64TZChapel Hill Flying Club DBA · Sanford, NCBuilt 1981 · S/N 28-8216081 N64WLLawrence Brian · Seal Beach, CABuilt 1997 · S/N 9612 N64YUCane Creek Aviation LLC · Asheville, NCBuilt 2004 · S/N 25997 N65001Dornak Henry E Jr · Corpus Christi, TXBuilt 1982 · S/N 17275665 N65003Major Air LLC · Charleston, SCBuilt 1982 · S/N 17275666 N6500ERegistered aircraftBuilt 2005 · S/N 10246 N6500JHorizon Aviation LLC · Brooks, GABuilt 1968 · S/N 28-4933 N6500UWhitson Mark A · Houston, TXBuilt 1962 · S/N 2253 N6501Ramirez Ricardo M · Camano Island, WAS/N 100-2 N6501CGcbc LLC · Norman, OKBuilt 1978 · S/N 28-7816428 N6501JAndersen Aviation LLC · Leavenworth, WAS/N 28-4934 N6501RAbove Earth Aerospace LLC · Friendswood, TXBuilt 1974 · S/N M-1537 N6501WStewarts Aircraft Service Inc · Waynesville, OHBuilt 1964 · S/N 28-20578 N6502Keen Brandon M · Brunswick, MEBuilt 1962 · S/N 28-566 N65021Borda Anthony J · West Chester, PABuilt 1982 · S/N 17275670 N6502JGanuza Diego J · Okeechobee, FLBuilt 1968 · S/N 28-5114 N6502WMid American Pilot Association Inc · Lawrenceville, ILBuilt 1965 · S/N 28-20579 N6503BSmith Gregory E · Manila, ARFirst renewal noticeBuilt 1957 · S/N 1170 N6503DManubay John M · Sinking Spring, PABuilt 1979 · S/N 17272834 N6503JTischler Keith Louris · Round Rock, TXBuilt 1968 · S/N 28-4938 N6503UMooney 6503u LLC · Naples, FLBuilt 1962 · S/N 2257 N6503VSt Cloud Technical & Community College · Saint Cloud, MNBuilt 1980 · S/N 172RG0736 N65045Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1982 · S/N 17275674 N6504CBraddy James R Jr · Sunnyvale, TXBuilt 1978 · S/N 28-7890377 N6504RJohn M Peters · Damascus, MDBuilt 1974 · S/N MB-716 N6504VYoung Charles Wade · Rogers, ARBuilt 1980 · S/N 172RG0737 N65057Good Winds LLC · Waterville, MEBuilt 1982 · S/N 17275677 N65058Organization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1982 · S/N 17275678 N6505JWedel Dan P · Fairmont, MNBuilt 1968 · S/N 28-4941 N6505UBell Keith O · Navarre, FLBuilt 1962 · S/N 2259 N6505WOndracek Jack E · Port Orchard, WABuilt 1964 · S/N 28-20582 N65065Angel Aviation Inc · Peoria, AZBuilt 1982 · S/N 17275681 N6506AFallon Timothy R · Ithaca, NYBuilt 2005 · S/N 10247 N6506DWhitefish Mountain Acft Rentals & Flt School LLC · Whitefish, MTBuilt 1979 · S/N 17272835 N6506ULambert Isabelle O · El Paso, TXBuilt 1962 · S/N 2260 N6506WRoehrig Michael A · Fairport, NYBuilt 1965 · S/N 28-20583 N6507CBollum Justin Keith · Chevy Chase, MDS/N 28-7816533 N6507RJoachim Peter · Grafton, WIBuilt 1974 · S/N MB-724 N6507UBovey Dominic C · Sandpoint, IDBuilt 1962 · S/N 2261 N6508HBkb Inc · Newport, MIBuilt 1975 · S/N 17265469 N6508KTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1980 · S/N 17274205 N6508RSterling Creek LLC · Brookings, SDBuilt 1974 · S/N M-1583 N6509HSale Reported · Benton, KSSale reportedBuilt 1975 · S/N 17265470 N6509JRoot Rickey · Nederland, TXBuilt 1968 · S/N 28-4945 N6509RHolzhauer Aviation Corp · Middletown, DEBuilt 1974 · S/N M-1584 N650FLHarps Thomas B · Vilonia, ARBuilt 1971 · S/N 28-7125559

Back to AD 80-04-03 R2