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.

N5130TInfinity Aviation LLC · Piedmont, SDS/N 76 N5130WMccutcheon Ernest Thomas · Ninety Six, SCBuilt 1961 · S/N 28-157 N5131Registered aircraftBuilt 1966 · S/N GC-1-66 N5131EBrunken Barry D · Tower Hill, ILBuilt 1978 · S/N 17271726 N5131LSkipper Up LLC · Herron, MIS/N 28-4414 N5131RMlt Operations LLC · Traverse City, MIBuilt 1974 · S/N 17263348 N5131VBuswell Aviation Inc · Salem, ORBuilt 1961 · S/N SP27 N5131WArias Timothy R · Tempe, AZBuilt 1961 · S/N 28-158 N5131XWilson Brent S Trustee · Dyer, NVBuilt 1969 · S/N 184 N5132HMohnacs Joseph T · Mount Laurel, NJBuilt 1975 · S/N 17265347 N5132LMongare Job · Athens, TXBuilt 1967 · S/N 28-4415 N5132PMccormick Geoffrey D · Goodyear, AZBuilt 1958 · S/N 24-145 N5132QHauptman Ben · Alexandria, VABuilt 1973 · S/N 17261760 N5132SFightin Fourth Line Pilots LLC · Gig Harbor, WABuilt 1971 · S/N 28-7105176 N5132ULiberty Exploration Inc · Las Vegas, NVS/N 172RG0250 N5132VFord Lynn W · Gibsonia, PABuilt 1961 · S/N SP-28 N5132WSmith Dale S · Grass Valley, CABuilt 1961 · S/N 28-161 N5132XLinch Travis R · Belle Fourche, SDS/N 147 N5133Small Gaston Elvin III · Elizabeth City, NCBuilt 1968 · S/N 1010 N51330Cortez Flying Service Inc · Cortez, COBuilt 1980 · S/N 17274298 N5133GPioneer Aviation LLC · Crossett, ARBuilt 1969 · S/N 17258447 N5133HBlydenburgh Daniel R · Palmer, AKBuilt 1948 · S/N 14-144 N5133LBiederman Clifton E · Jasper, FLBuilt 1967 · S/N 28-4416 N5133PMoore Buck B · Wasco, CABuilt 1958 · S/N 24-146 N5133QReed Aero Group LLC · Hendersonville, TNBuilt 1973 · S/N 17261761 N5133SMcclelland Kip · Douglas, GABuilt 1971 · S/N 28-7105177 N5133TRanspot Richard P · Burlington, TXBuilt 1966 · S/N 76 N5133VFlying Monkey LLC · Wilmington, DEBuilt 1961 · S/N SP-29 N5134GRegistration Pending · Cannon Falls, MNRegistration pending, pending cancellationBuilt 1969 · S/N 17258448 N5134LPmd Services LLC · Wilmington, DEBuilt 1967 · S/N 28-4417 N5134TLawrence David Denton · Roanoke, VABuilt 1966 · S/N 75 N5135ECommercial Safe And Lock Inc · Imperial, MOBuilt 1978 · S/N 17271728 N5135GChinrock Adam · Spanish Fort, ALBuilt 1969 · S/N 17258449 N5135HKinneen Simon N · Nome, AKBuilt 1948 · S/N 14-145 N5135LBolden Robert P · Uvalda, GABuilt 1967 · S/N 28-4418 N5135SThompson Eric H · Tucson, AZBuilt 1971 · S/N 28-7125467 N5135VLochner Richard A · Eagle River, AKBuilt 1961 · S/N SP-31 N5136DZieg James E · Goldsboro, NCBuilt 1979 · S/N 17272432 N5136EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271729 N5136GYork Aviators LLC · York, PAS/N 17258450 N5136LBerkowitz Bruce · Poughkeepsie, NYBuilt 1967 · S/N 28-4419 N5136PDunn James F · Salem, INBuilt 1958 · S/N 24-150 N5136UNg Raymond Fong · New York, NYBuilt 1980 · S/N 172RG0252 N5136WGreen Patric S · Stillwater, OKBuilt 1961 · S/N 28-165 N51379N51379 LLC · Galena, OHBuilt 1974 · S/N 17264235 N5137LSky Vector LLC · Rustburg, VABuilt 1967 · S/N 28-4421 N5137MFuture Pilots Of America Flight Academy LLC · Baxley, GABuilt 1978 · S/N MB-890 N5137PFrancis Himanshu Raj · Blythewood, SCBuilt 1958 · S/N 24-151 N5137RSchmeelk Darrin D · Thompson, CTBuilt 1974 · S/N 17263354 N5137VBurns Mark G · Anacortes, WABuilt 1962 · S/N SP33

Back to AD 80-04-03 R2