Registered aircraft · 72,007

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:87-10-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1') 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:87-10-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
  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:87-10-06-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-10-06-R1')
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.

N312FMBosch Jay E · Atwater, MNBuilt 2013 · S/N 82162 N312JMMiller James D · Sun Prairie, WIBuilt 2004 · S/N 81175 N312JTInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 5135 N312KKHowser Donald Marvin III · Granbury, TXBuilt 2004 · S/N T20608472 N312LLNilsen Christopher · Livermore, CABuilt 1964 · S/N 194 N312MMBadgley Robert W · Stanley, NDBuilt 1976 · S/N 25-7656085 N312PDValdosta Flying Service Inc · Valdosta, GABuilt 2000 · S/N 172S8408 N312PSCon Air LLC · Lake Providence, LABuilt 1998 · S/N 6011 N312PZMatrix Commerce Solutions LLC · Pt Pleas Bch, NJS/N 92252 N312RACross Country Soaring Inc · Lonsdale, MNBuilt 1977 · S/N 12937 N312RBBarcelona Russell J · Buffalo, NYBuilt 2024 · S/N MK-0077 N312RHOstendorf Mark W · Santa Barbara, CABuilt 1986 · S/N 1898 N312RMSunny Days Prop Jox LLC · Niceville, FLBuilt 2000 · S/N 18280872 N312SLKeith Shon D · Flandreau, SDBuilt 2013 · S/N 82645 N312SMShelbyville Flight Academy LLC · Smyrna, TNBuilt 1977 · S/N 17270091 N312TATaylor Charles E · Glen Ellyn, ILBuilt 1979 · S/N 17273565 N312TDAircom Nwa LLC · Siloam Springs, ARBuilt 1976 · S/N 17266129 N312TMVan Hofwegen Douglas E · Spencer, IABuilt 1973 · S/N 28-7305382 N312TSWoodford John E · Madison, WIBuilt 1998 · S/N 408-98 N3130RN738yc LLC · Fresno, CABuilt 1969 · S/N 28R-31115 N3131TSilver Express Co Db · Miami, FLBuilt 2004 · S/N 2844107 N3131ZPralle Jeffory K · Wasilla, AKBuilt 1959 · S/N 22-7076 N3132CBlack Eric · Fort Jones, CABuilt 1978 · S/N R18200238 N3132FN3132f LLC · Metairie, LABuilt 1973 · S/N 32-7440023 N3132PSarratt Curtis H · Annapolis, MDBuilt 1957 · S/N 23-1056 N3132TUballe Ruben · Axtell, TXBuilt 1967 · S/N 17700432 N3133PLumley John J · Delray Beach, FLFirst renewal noticeBuilt 1957 · S/N 23-1057 N3133QLearn 2 Fly Ct LLC · Simsbury, CTBuilt 1977 · S/N 28-7716138 N3133TGiddy Up Aviation LLC · Ada, OKBuilt 1967 · S/N 17700433 N3134PSchmidt Casey D · Cedar Rapids, IAS/N 23-1059 N3134WDans Flying Service Inc · Crookston, MNS/N 19027C N3135EHerring Christopher E · Granbury, TXBuilt 1978 · S/N 17271447 N3135GDrake Michael L · Bellevue, WABuilt 1995 · S/N 20513 N3135RSerna Alvaro V · San Antonio, TXBuilt 1969 · S/N 28R-31117 N3136ZSchafer Patrick A · Marietta, OHBuilt 1959 · S/N 22-7080 N31377Piercy Brian A · Kalispell, MTBuilt 1978 · S/N 32-7840126 N3137ERegistered aircraftBuilt 1978 · S/N 17271448 N31380Aldred John B · Washoe Valley, NVBuilt 1978 · S/N 32-7840127 N31385Registration Pending · Missoula, MTRegistration pendingBuilt 1978 · S/N 28-7816554 N31388Sisk Farms LLC · Hopkinsville, KYBuilt 1978 · S/N 32-7840128 N3138CTurbo-Sphere Inc · Longmont, COBuilt 1978 · S/N R18200239 N3138TJones Daniel D · Ekron, KYBuilt 1968 · S/N 17700438 N31396Pucciarelli Albert J · Ridgewood, NJBuilt 1978 · S/N 32-7840129 N31397Ial Corp · Lewes, DES/N 32R-7885093 N31399G&M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 28-7816556 N313ACAero Craft Of Bloomington LLC · Bloomington, ILBuilt 1977 · S/N 28-7816013 N313AMRademacher John · Cottonwood, AZBuilt 1979 · S/N 28-8011015 N313BLDaggett Keith W · Rockport, MEBuilt 1976 · S/N 17267097 N313CHSlater Timothy R · Poplar Grove, ILBuilt 1991 · S/N 3017 N313CWJackson Kimberly L · Show Low, AZBuilt 1996 · S/N 1001

Back to AD 87-10-06 R1