Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N512FLReiley Allen Ted · Lavernia, TXBuilt 1971 · S/N 28-7125336 N512JHHenson David · Fallon, NVBuilt 2004 · S/N 90468 N512MACurrie George H III · Fleming Island, FLBuilt 1977 · S/N 28-7716224 N512MSTiralongo Sebastiano · Weston, FLBuilt 1992 · S/N 2841349 N512RSRollison Michael W · Fairfield, PABuilt 2003 · S/N 001 N512SInternational Air Services Inc Trustee · Carson City, NVS/N 512 N512TMSouthern Flight Aviation LLC · Bainbridge, GABuilt 1978 · S/N 17271721 N5130EAviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 17271725 N5130HCalkins David Martin · Anchorage, AKBuilt 1949 · S/N 14-141 N5130LSalisbury Gershom · Prescott, AZBuilt 1967 · S/N 28-4413 N5130PWhite Guy B · Waxahachie, TXBuilt 1958 · S/N 24-143 N5130RShamp Jimmy L · Fresno, CABuilt 1974 · S/N 17263347 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

Back to AD 79-10-03 R2