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.

N8829PInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 24-4285 N882JVBtl Consulting Inc · Vienna, ILBuilt 2006 · S/N T18208517 N8832PRoundtree Benjamin · Cass City, MIBuilt 1965 · S/N 24-4288 N8833PRegistered aircraftBuilt 1965 · S/N 24-4289 N8833VMeyr Richard J · Reno, NVBuilt 1971 · S/N 32-46 N8835PFeller James P · Granite Bay, CABuilt 1965 · S/N 24-4291 N883HPStudio 15 Commercial Interiors Inc · Cherokee, NCBuilt 2000 · S/N T20608235 N883KKLegacy Aviation LLC · Tigard, ORBuilt 2023 · S/N T18209127 N8840PStutzman John M · Grand Rapids, MIBuilt 1965 · S/N 24-4295 N8841PBotsacos Chris S DBA · Long Beach, CABuilt 1965 · S/N 24-4296 N8842PGauss Roger W · Forest Hill, MDBuilt 1965 · S/N 24-4297 N8843PRodarte Lionel A · Downey, CABuilt 1965 · S/N 24-4298 N8844PReetz Roger D · Duluth, MNBuilt 1965 · S/N 24-4299 N8848PLazar Stephen D · Toledo, OHBuilt 1965 · S/N 24-4303 N8849PCare Management Oregon Inc · New Plymouth, IDBuilt 1965 · S/N 24-4304 N884CCRegistered aircraftBuilt 2001 · S/N 3257221 N884TWJerk Assets LLC · Bakersfield, CABuilt 2011 · S/N T20609011 N8850PSharp Alan D · Dallas, TXBuilt 1965 · S/N 24-4305 N8851PRegistered aircraftBuilt 1965 · S/N 24-4307 N8853CEuropa Aero LLC · Bucyrus, OHBuilt 1976 · S/N 32R-7680141 N8853PGebhart Kevin E · Burley, IDBuilt 1965 · S/N 24-4309 N8858PMachmiller A A · San Jose, CABuilt 1965 · S/N 24-4315 N8859PGowins John C · New Philadelphia, OHBuilt 1965 · S/N 24-4317 N885HAFox Airways LLC · Wasilla, AKS/N 31-7405416 N885MMBrickyard Aviation LLC · Indianapolis, INBuilt 2008 · S/N 4692085 N8861PForney Garry L · El Centro, CABuilt 1965 · S/N 24-4318 N8862VInternational Air Services Inc Trustee · Carson City, NVBuilt 1971 · S/N 31022 N8864VAnthony Baruth · Saint Joseph, MOBuilt 1971 · S/N 32-48 N8865PBrown Travis E · Leicester, NCBuilt 1965 · S/N 24-4322 N8868VWard Steven E · Wilbur, WABuilt 1972 · S/N 32-62 N886JAIndustrial Equities Aircraft Leasing LLC · Naples, FLBuilt 2018 · S/N T20609552 N886MCKennedy Chad Everard · Jupiter, FLBuilt 2008 · S/N T20608861 N886PSSynapse Electric · Muir Beach, CABuilt 2012 · S/N T20609072 N8870VOklahoma Historical Steam Engine Museum Foundation · Oklahoma City, OKS/N 32-52 N8872PBlackburn Robert F · Georgetown, TXBuilt 1965 · S/N 24-4329 N8873PTailwind Auditing Group LLC · Godley, TXBuilt 1965 · S/N 24-4330 N8878PHudson Albert Denning · Cornelius, NCBuilt 1965 · S/N 24-4337 N8881PIce Randall R · Pierre, SDBuilt 1965 · S/N 24-4340 N8883PFlynn James Jay · Seneca, SCBuilt 1965 · S/N 24-4342 N88847So-Do Holdings LLC · Monticello, GAS/N 32R-7680354 N8888X82 Saratoga LLC · Bryant, ARBuilt 1989 · S/N 4622078 N888EBCharcoals Smokehouse LLC · Katy, TXBuilt 1977 · S/N 32R-7780194 N888EGMooney N888eg LLC · Granbury, TXBuilt 1989 · S/N 27-0021 N888JJGst Inmotion LLC · Kalispell, MTBuilt 1978 · S/N 317852078 N888LMAir Mods And Repair · Robbinsville, NJS/N 31-7405464 N888PCAirmonarc LLC · Orlando, FLBuilt 1981 · S/N 31-8152086 N888PEPacific Flight Academy LLC · Honolulu, HIBuilt 1977 · S/N 27-7754066 N888RJMongini David · Cottonwood, AZBuilt 1973 · S/N 27-7305139 N888RYScrap Sales LLC · Manly, IABuilt 2025 · S/N T18209173 N888TMFive G Aviation LLC · Nampa, IDBuilt 1974 · S/N 32-7440132

Back to AD 71-13-01 R1