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.

N8RUN8ru LLC · Sedona, AZBuilt 1976 · S/N 31-7612109 N8ZBEastern Nevada Aviation LLC · Gardnerville, NVBuilt 1997 · S/N 3257011 N9004PFlying R Aviation LLC · Cherokee, IAS/N 24-4465 N9006FSeasky27 Productions LLC · Forked River, NJBuilt 1976 · S/N 32R-7780121 N9006PSage Building Construction Inc · Roosevelt, UTBuilt 1966 · S/N 24-4467 N9007PKoval Andor A · Yerington, NVBuilt 1966 · S/N 24-4468 N9008PStarnes William H · Eureka Springs, ARBuilt 1966 · S/N 24-4469 N9009YConchas Abel · Boiling Springs, SCBuilt 1967 · S/N 31-14 N900AKNorthern Aviation LLC · Palmer, AKBuilt 1976 · S/N 61P-0365-115 N900BWWilliams Rebecca J · Alto, NMBuilt 2025 · S/N T20609789 N900CGMarc Inc · Bolton, MSBuilt 1975 · S/N 31-7612002 N900GPPerkins E G Jr · Greenwood, MSBuilt 1966 · S/N 24-4464 N900JLRed Baron LLC · Pooler, GAS/N 32R-7680181 N900KKSpears Aerial Crop Care LLC · Mamou, LABuilt 2005 · S/N T18208401 N900MASdp Air Inc · Memphis, TNBuilt 2007 · S/N 4636406 N900NFPetros LLC · Bend, ORS/N T18208494 N900TSMidwest Flying Service Inc · Sheldon, IABuilt 1974 · S/N 27-7405429 N900WEWe Logistics LLC · Locust Valley, NYBuilt 2021 · S/N T20609629 N9013PRegistered aircraftBuilt 1966 · S/N 24-4474 N901BLMaritime Helicopters Inc · Homer, AKBuilt 1971 · S/N 32-7140030 N901BWKraft Tyrone H · Timber Lake, SDBuilt 1976 · S/N 32R-7680451 N901CArchambault James M · Destin, FLBuilt 2010 · S/N 4692144 N901MAWings Of Ber LLC · Fort Payne, ALBuilt 2000 · S/N 46-36301 N901SRFalckon LLC · North Providence, RIBuilt 2019 · S/N T20609593 N9020PLindsay Terry M · West Hills, CABuilt 1966 · S/N 24-4482 N9021PFontenot Monty Jason · Aiken, SCBuilt 1966 · S/N 24-4483 N90227Waring Marvin Barton · Anacortes, WABuilt 2010 · S/N T20608985 N9022PAcc Air Charter Company · Wilmington, DEBuilt 1966 · S/N 24-4484 N9023PHand Joseph Michael · Sheboygan Falls, WIBuilt 1966 · S/N 24-4485 N9024PBlue Skies Above LLC · Bogart, GABuilt 1966 · S/N 24-4486 N9025FSoulant Michael B · Montgomery, TXBuilt 2010 · S/N T20608986 N9025PIdeation Machine LLC · Las Vegas, NVS/N 24-4487 N9028Leimgruber Logistics LLC · Holtville, CABuilt 2011 · S/N T20609028 N9028PBray Nick R Trustee · China Spring, TXBuilt 1966 · S/N 24-4490 N9029PEzzell Stephen Mark · Statesville, NCS/N 24-4491 N90339Bas Part Sales LLC · Greeley, COBuilt 1975 · S/N 61P-0196-015 N9033PMiddletown LLC · Chandler, AZBuilt 1966 · S/N 24-4495 N90349Williams David Anthony · Port Saint Lucie, FLBuilt 1975 · S/N 60-0202-090 N9034PNational Test Pilot School · Mojave, CABuilt 1966 · S/N 24-4496 N9037PJack Ryan Aviation · Woodcliff Lake, NJS/N 24-4500 N903KACorsair Aviation LLC · Yuba City, CABuilt 2011 · S/N T20609033 N9042PWt Del Pl LLC · Newark, DEBuilt 1966 · S/N 24-4505 N904JDTd Ventures Inc · Las Vegas, NVBuilt 2000 · S/N T20608195 N904SCMedical Disposables Corp · Orlando, FLBuilt 1981 · S/N 31-8152194 N90509Mccollum Timothy L · Toccoa, GABuilt 1976 · S/N 60-0297-111 N9050PFrisbee Robert P · Mcminnville, ORBuilt 1966 · S/N 24-4515 N9052PVentura Alejandro · Lakeside, CABuilt 1966 · S/N 24-4518 N9053POhlstein Michael R · Glen Head, NYBuilt 1966 · S/N 24-4519 N9055PB Dot Air LLC · Jackson, WYBuilt 1966 · S/N 24-4521 N9056PMarion Brian R · Denver City, TXBuilt 1966 · S/N 24-4522

Back to AD 71-13-01 R1