Skip to content

Registered aircraft · 6,916

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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.

N8969NMatanane Roke C · Barrigada, GUBuilt 1970 · S/N 32-40769 N896SJTumbleweed Aviation LLC · Great Bend, KSBuilt 1996 · S/N 46-36033 N8970PPodraza Kevin M · Dekalb, ILBuilt 1966 · S/N 24-4427 N8972PHardy Douglas · Lakewood, CABuilt 1966 · S/N 24-4429 N8973PBrockwell Derrell Randel · Oakland, TNBuilt 1966 · S/N 24-4430 N8977PWarrior Up LLC · Clayton, NCBuilt 1966 · S/N 24-4435 N8979NPeeling Clyde R · Allenwood, PABuilt 1969 · S/N 32-40862 N8980PLittle Wood LLC · Bellevue, MIBuilt 1966 · S/N 24-4439 N8982PAviation & Aerospace Consulting & Mgmt Svcs LLC · Bullhead City, AZBuilt 1966 · S/N 24-4441 N8984NBlair Gary B · Salado, TXBuilt 1969 · S/N 32-40867 N8984PMarchant Scott · Clackamas, ORBuilt 1966 · S/N 24-4443 N8985CCornelius James Sean · Hamilton, MOBuilt 1976 · S/N 32R-7680147 N8985PSharp Charles Barry · Fulton, KYBuilt 1966 · S/N 24-4445 N8986NBay Air Inc · Dillingham, AKS/N 32-40869 N8986PNielsen James R · Carson City, NVS/N 24-4446 N8987CDouble M Charters LLC · Lakeland, FLBuilt 1976 · S/N 32R-7680148 N8988NCicero Flying Club LLC · Indianapolis, INBuilt 1969 · S/N 32-40871 N898CPThomas Robert M Jr · Kissimmee, FLBuilt 1975 · S/N 32-7640031 N898DSBeretta James P · Indian Springs, ALBuilt 1977 · S/N 32R-7780358 N898MXHicks Jeff D · Caldwell, IDBuilt 2006 · S/N T18208507 N8990PBaitanator Inc · Lamesa, TXBuilt 1966 · S/N 24-4451 N8991PCendejas Agustin · Chino, CABuilt 1966 · S/N 24-4452 N8992NBenedict Kevin M · Lakeland, FLBuilt 1970 · S/N 32-40875 N8992PL And L Aviation Inc · Mount Airy, MDBuilt 1966 · S/N 24-4453 N8993PPitcher Benjamin Alan · Fishers, INBuilt 1966 · S/N 24-4454 N8996NBickford Shawn A · Auburn, CABuilt 1969 · S/N 32-40879 N8997PF2 Management LLC · Canoga Park, CAS/N 24-4458 N8998NHangar Cc5 LLC · Gainesville, GABuilt 1969 · S/N 32-40881 N8998PMoore Jeffrey · Oceanside, CABuilt 1966 · S/N 24-4459 N8999PBednorski Craig A Trustee · Grass Valley, CABuilt 1966 · S/N 24-4376 N899CSGilbert John · Austin, TXBuilt 2011 · S/N T20608999 N899ETAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2016 · S/N T20609203 N899MEGv Air Inc · Medford, ORBuilt 2011 · S/N T20609036 N89BRN89br LLC · Wilmington, DEBuilt 1967 · S/N 27-3618 N89FMRadia LLC · Castro Valley, CAS/N 27-0268 N89GBHerrington Kevin · Honey Grove, TXS/N 24-4779 N89PABrewer Robert Kevin · North Bend, ORBuilt 2000 · S/N T20608157 N89PMLittle Dreams Aviation LLC · Washingtn Twp, MIBuilt 2013 · S/N 4636613 N89SGalaxy Aviation LLC · Nantucket, MABuilt 2017 · S/N T20609524 N89VY7ae LLC · La Habra Heights, CABuilt 2000 · S/N T20608249 N8APMatthews Aviation LLC · Hardinsburg, KYBuilt 1973 · S/N 27-7305072 N8AQMiller Donald W · Harrisonburg, VABuilt 1975 · S/N 61P-0222-027 N8CTOpitz Airways Inc · Belleair, FLBuilt 1973 · S/N 27-7305094 N8EMHaase Robert F · Vienna, VABuilt 2011 · S/N T18209042 N8LXAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 3065 N8NYTap Family Corp · Wilmington, DEBuilt 2002 · S/N 3257270 N8PRegistered aircraftBuilt 2025 · S/N T18209179 N8PK8 Papa Kilo LLC · Saint Petersburg, FLBuilt 2025 · S/N T20609794 N8PT10wg LLC · Newman Lake, WABuilt 1973 · S/N 32-7440024 N8RGGrimes Raymond L Trustee · Los Alamitos, CABuilt 1979 · S/N 32R-8029012

Back to AD 71-13-01 R1