Skip to content

Registered aircraft · 5,102

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-12-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:81-12-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:81-12-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:81-12-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:81-12-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:81-12-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.

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 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 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 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 N8LXAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1969 · S/N 3065 N8NYTap Family Corp · Wilmington, DEBuilt 2002 · S/N 3257270 N8PT10wg LLC · Newman Lake, WABuilt 1973 · S/N 32-7440024 N8RGGrimes Raymond L Trustee · Los Alamitos, CABuilt 1979 · S/N 32R-8029012 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 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 N900NFPetros LLC · Bend, ORS/N T18208494 N900TSMidwest Flying Service Inc · Sheldon, IABuilt 1974 · S/N 27-7405429 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 N901MAWings Of Ber LLC · Fort Payne, ALBuilt 2000 · S/N 46-36301

Back to AD 81-12-06 R1