Skip to content

Registered aircraft · 930

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:76-14-07-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-14-07-R2') 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:76-14-07-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-14-07-R2')
  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:76-14-07-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:76-14-07-R2')
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.

N6866ROrnes W Harold · Aiken, SCBuilt 1967 · S/N T210-0266 N6868RChrisman Charles Griggs · Denver, COS/N T210-0268 N6884XBaked Industries Inc · Yuba City, CABuilt 1960 · S/N 21057664 N6889RShelton L Wayne · Rifle, COBuilt 1967 · S/N T210-0289 N6901RFritz Douglas R · Anacortes, WABuilt 1967 · S/N T210-0301 N6909Mcgrew Aaron · Bremen, GABuilt 1958 · S/N 57514 N6909RMitchell Greg · Pecos, TXBuilt 1967 · S/N T210-0309 N6910RDirty Birdy Aviation LLC · Silt, COBuilt 1967 · S/N T210-0310 N6924RTurbo Centurion LLC · Vail, AZBuilt 1967 · S/N T210-0324 N6925RDelong Mark B · Rock Springs, WYBuilt 1967 · S/N T210-0325 N6927RSavord George Kevin · Boulder City, NVBuilt 1967 · S/N T210-0327 N6929RShelfer Douglas · Arlington, TXBuilt 1967 · S/N T210-0329 N6931RFender Darrell L · Garfield, WABuilt 1967 · S/N T210-0331 N6932RBoxwell Avionics · Green Cove Springs, FLS/N T210-0332 N6936RKingrey William S III · Richmond, TXBuilt 1967 · S/N T210-0336 N6939RGalloway Kyle J · Bradshaw, NEBuilt 1967 · S/N T210-0339 N6944RSilcox Cleven L · Sapulpa, OKBuilt 1968 · S/N T210-0344 N6945RDonham William David · Odessa, TXS/N T210-0345 N6946RGrosslight Gordon · Westcliffe, COBuilt 1968 · S/N T210-0346 N6949RElyan Aviation Inc · Palm Springs, CABuilt 1968 · S/N T210-0349 N6969YTorres Charles O · Riverside, CABuilt 1966 · S/N T210-0150 N6990YV Speed Aviation LLC · Reno, NVBuilt 1964 · S/N 21058490 N699WWWallis Warren · Barstow, CABuilt 1969 · S/N 21059161 N69PRAero Inventory LLC · Monroe, GAS/N T210-0321 N69RLLivingston Robin L · Vail, AZBuilt 1960 · S/N 57287 N7014ESkinner Norman D · Osceola, IABuilt 1964 · S/N 21058334 N707CDPadilla Luis Antonio Jr · Brownsville, TXBuilt 1963 · S/N 21058207 N70TCTwo Ten Bravo Delta LLC · Kaiser, MOBuilt 1977 · S/N 21061707 N711ZGHutton Mark B · Denison, TXS/N 21061817 N727FKVan Schoonhoven Peter · Battle Ground, WABuilt 1967 · S/N 21058912 N7327ELarsen James M · Santa Rosa, CABuilt 1959 · S/N 57027 N7340EStoberski John J · Henderson, NVBuilt 1959 · S/N 57040 N7343ELemanski Joseph S · Grosse Ile, MIBuilt 1959 · S/N 57043 N7350EMuszynski Jerry · Huntington Beach, CABuilt 1959 · S/N 57050 N7352ELandgraf James P Trustee · Camas, WABuilt 1960 · S/N 57052 N7353EFitzpatrick Michael H · Anchorage, AKBuilt 1959 · S/N 57053 N7356EJouppi Kenneth J · Ward Cove, AKBuilt 1959 · S/N 57056 N735FViolette Charles H · Alto, NMBuilt 1959 · S/N 57005 N735SDavis Brady L · Monument, COBuilt 1959 · S/N 57013 N7360EShacklette Donald J · Smiths Grove, KYBuilt 1960 · S/N 57060 N7364EGreat Commission United · Montague, MIBuilt 1960 · S/N 57064 N7366EZarko David S · Fenton, MIBuilt 1960 · S/N 57066 N7373EQuist Donald G · Ridgecrest, CABuilt 1960 · S/N 57073 N7381EDill Terry L · Delphi, INBuilt 1960 · S/N 57081 N7385EGibson Gregory T · Ivel, KYS/N 57085 N7386ESwensen Nathan E · Winnemucca, NVS/N 57086 N7389EWeber James D · Benton City, WABuilt 1960 · S/N 57089 N7393ECardenas Christian · Saint Augustine, FLBuilt 1960 · S/N 57093 N7395ERegistered aircraftBuilt 1959 · S/N 57095 N7398EGriffith John M · Seatac, WABuilt 1960 · S/N 57098

Back to AD 76-14-07 R2