Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N431BTTrout Robert J · Brownsburg, INBuilt 1983 · S/N 25-0755 N431XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 6186C N4324DHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1983 · S/N 34-8433019 N4327NFederal Fire And Security LLC · Owensboro, KYBuilt 1983 · S/N 34-8433026 N432SAMma Consulting Inc · Chestnut Hill, MABuilt 2002 · S/N 3449232 N432WHRouw Bruce L · Leesburg, FLBuilt 2007 · S/N 714-320-558FB N4333GHuebscher Attila · Pittstown, NJBuilt 1984 · S/N 34-8433048 N4335XPine Valley Aviation LLC · Waycross, GABuilt 1983 · S/N 28R-8431009 N433MJCousin Elisabeth Trustee · Pompano Beach, FLBuilt 2004 · S/N 1469 N4340GHaynie Airline LLC · Boca Raton, FLBuilt 1984 · S/N 28R-8431015 N4343PEnvironmental Enterprises Inc · Cincinnati, OHBuilt 1984 · S/N 34-8433034 N4348MDavison Noel C · Covington, KYBuilt 1984 · S/N 28R-8431020 N4348YFlamingo Express LLC · Jacksonville, FLBuilt 1984 · S/N 34-8433040 N4349AJensen Jay Delayne · Cabot, ARBuilt 1984 · S/N 28R-8431013 N4355NPiper Aircraft Inc · Vero Beach, FLBuilt 1984 · S/N 28R-8431023 N4358XSga Alaska Leasing LLC · Anchorage, AKBuilt 1975 · S/N 34-7670027 N4360MOwen Kevin R Trustee · Camdenton, MOBuilt 1984 · S/N 34-8433058 N43613Piper Aircraft Inc · Vero Beach, FLBuilt 1984 · S/N 34-8433068 N4369XSand Duane A · Bismarck, NDBuilt 1975 · S/N 34-7670030 N43761Gedney Greg Monroe · Denver, COBuilt 1977 · S/N 28R-7703310 N43764Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N 28R-7703312 N43794Ochoa Luis M · Hollywood, FLBuilt 1977 · S/N 28R-7703314 N437ALBier Ervin D · Locust Grove, GABuilt 1981 · S/N 348133156 N43848White David W · New River, AZS/N 28R-7703317 N4387FValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 34-7670336 N43970Arrow N43970 LLC · Derry, NHBuilt 1977 · S/N 28R-7703321 N43994Harrison Shawn · Salisbury, MDBuilt 1977 · S/N 28R-7703327 N43GRN43gr LLC · Phoenix, AZS/N 1531 N43PGBender Brian C · Los Angeles, CABuilt 1998 · S/N 25-2019 N43WGMaxfield Kenneth B Trustee · Murray, UTBuilt 1977 · S/N 28R-7703280 N43WRLanaux Antoine D IV · Metairie, LABuilt 2011 · S/N 71368 N43WTSummit Aviation LLC · Dover, NHBuilt 1983 · S/N 25-0792 N440DMBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 34-7670040 N441CLShumate Jeff B · Mcminnville, ORBuilt 2010 · S/N 1753 N442GBas Part Sales LLC · Greeley, COBuilt 1977 · S/N 28R-7703208 N4430XIsland Piper LLC · Portland, ORBuilt 1975 · S/N 34-7670041 N4441XKaschak Tom · Stateline, NVBuilt 1975 · S/N 34-7670043 N4446XRegistration Pending · Las Vegas, NVRegistration pendingBuilt 1975 · S/N 34-7670044 N444HPCrosswind Aviation Inc · Oakley, KSBuilt 1979 · S/N 28R-8031003 N444JSIndigo Of South Fl Inc · Sunrise, FLS/N 28R-7703287 N444PAExecutive Aviation LLC · Peoria, AZBuilt 1979 · S/N 34-7970324 N444TKFahl James E · Sparks, NVBuilt 1981 · S/N 25-0576 N444WLX-Perimental Aircraft LLC · Kenosha, WIBuilt 1994 · S/N 7 N44552Hemdmm Corp · Wilmington, DEBuilt 1974 · S/N 34-7570003 N4458XBabichix Inc · Hiram, GAS/N 34-7670049 N4462BRussell Industries Inc · Millcreek, UTS/N 336-0159 N446CDMichiana Air Activities Inc · Osceola, INBuilt 2004 · S/N 1446 N446DWAnnes Wings LLC · Boulder, COBuilt 1978 · S/N 34-7870051 N446SNWarren Dennis · Las Vegas, NVBuilt 1966 · S/N 337-0454 N4479FDurosinmi Lateef · North Las Vegas, NVS/N 34-7670338

Back to AD 81-13-10 R1