Registered aircraft · 40,395

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.

N2560PBader Regan R · Saint Libory, NEBuilt 1955 · S/N 22-2923 N2562FMans David A · Gruver, TXBuilt 1965 · S/N 35 N2562KPodany John R · Aledo, TXBuilt 1988 · S/N 922 N2563UGrande Philip M · Mt Laurel, NJBuilt 1979 · S/N 28-8090057 N2565MMacair Aviation LLC · Xenia, OHBuilt 1977 · S/N 28-7890257 N2565UVintage Flyers Inc · Napa, CABuilt 1979 · S/N 28-8090058 N2566PClark William · Easton, MOBuilt 1955 · S/N 22-2929 N2566QCarothers Rayburn T · Brevard, NCBuilt 1977 · S/N 28-7725201 N2566UHighland Aero LLC · Mcminnville, TNBuilt 1980 · S/N 28-8090059 N2567LGolden Valley LLC · Missoula, MTS/N 18-8109014 N2567WSullivan Eric V · Santa Barbara, CABuilt 1965 · S/N 3271 N2568DPritchett Gregory L · Ozark, ALBuilt 2002 · S/N 5261 N2568JState Of Utah · Salt Lake City, UTBuilt 1979 · S/N 18-7909131 N2568QCasey William · Celina, TXBuilt 1977 · S/N 28-7716113 N2568RCraven James J · Pensacola, FLBuilt 1969 · S/N 28-5649 N2568WSale Reported · Modesto, CASale reportedBuilt 1965 · S/N 3272 N2569MSp Airparts LLC · Moscow, IDBuilt 1946 · S/N 12-940 N2569QWatch Ya Head Aviation I LLC · West Haven, UTBuilt 1977 · S/N 28-7790407 N256ACAtwood Jerry L · Sweet Home, ORBuilt 1956 · S/N 22-3788 N256AMEdwards Bruce D · Georgiana, ALBuilt 2003 · S/N 2256 N256ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496067 N256BSlayton Michael B · Grand Haven, MIBuilt 1957 · S/N 16 N256GDAugust Aero LLC · Kalispell, MTBuilt 2003 · S/N 23639 N256JD Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N ME-107 N256MWLease Air LLC · Moab, UTBuilt 1977 · S/N 17269958 N256SCNovember Alpha LLC · Dover, DEBuilt 2006 · S/N 4007 N2570PStaneli Lee A · Kiana, AKBuilt 1956 · S/N 18-4310 N2570UJla Aero LLC · State College, PABuilt 1979 · S/N 28-8016036 N2571HRiker Walter T · Anchorage, AKBuilt 1979 · S/N 18-7909200 N2571MBoston Breeze Aviation LLC · Woburn, MABuilt 1977 · S/N 28-7890258 N2571PStrick Steffen G · Mc Grath, AKBuilt 1955 · S/N 18-4311 N2571QLubbe Klaus · Bethlehem, NHS/N 28-7790408 N2571XRegistration Pending · Augusta, KSRegistration pendingS/N 28-8516037 N2572ASteinhoff Aaron M · Ethel, WABuilt 1952 · S/N 20-938 N2572LBuick Robin B · Redding, CABuilt 1973 · S/N A1500485 N2572PRegistration Pending · Roanoke, TXRegistration pendingS/N 18-4312 N2572UVan Scoy Bridget Anne · Shavertown, PAS/N 28-8016038 N2572WFlournoy Thomas H · Port Republic, NJBuilt 1965 · S/N 3273 N2572ZRunia Jerry L · Estelline, SDBuilt 1977 · S/N 1000-77 N2573JBusch Bruce K Trustee · Cerritos, CABuilt 1979 · S/N 18-7909132 N2573WTrail Air LLC · Springdale, ARBuilt 1965 · S/N 3274 N2574XBuckman Warren E III · Pennsburg, PABuilt 1985 · S/N 28-8516047 N2575UCavu Aircraft LLC · Salisbury, NCBuilt 1979 · S/N 28-8016042 N2576PWiltz Brothers Inc · Krotz Springs, LAFirst renewal noticeBuilt 1955 · S/N 18-4316 N2577MBales Colton E · Wasilla, AKBuilt 1946 · S/N 12-1051 N2577WSiegel Theodore Matthew · Merritt Island, FLBuilt 1965 · S/N 3275 N2578WCain Mitchell J · Ellisville, MOBuilt 1965 · S/N 3276 N2578ZMcclaskey Leslie Paul · New Albany, OHBuilt 1977 · S/N 348-77 N257ACClassic Aviation Inc · Pella, IABuilt 1999 · S/N 1257-99 N257ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496071

Back to AD 79-10-03 R2