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.

N3365SWinger Cattle Co Inc · Johnson, KSBuilt 1969 · S/N 21059165 N3366ST R Webster And Son Inc · Rexburg, IDBuilt 1969 · S/N 21059166 N3368SForbes Amanda M · Huachuca City, AZBuilt 1969 · S/N 21059168 N3369SC-210 Lc · Atlantic, IABuilt 1969 · S/N 21059169 N3372SBmf Services USA LLC · Satellite Beach, FLBuilt 1969 · S/N 21059172 N3374SCcf Ventures Inc · Bangor, MEBuilt 1969 · S/N 21059174 N3383SStewart Bryan · Carson City, NVBuilt 1969 · S/N 21059183 N3388SShaffer Barbara J · Franklin, KYBuilt 1969 · S/N 21059188 N3397SMcrae Richard · Kent, WABuilt 1969 · S/N 21059197 N33RNMurphey John L · Fredericksburg, VABuilt 1964 · S/N 21058533 N33SQJohnston H Kenneth II · Wheatland, WYBuilt 1966 · S/N T210-0056 N344KVLutz Gregory J · East Bridgewater, MABuilt 1960 · S/N 57470 N350TMJefferies Stanley J · Coos Bay, ORBuilt 1969 · S/N 21059125 N3601YFirst Cut Excavation LLC · Hamilton, MTBuilt 1962 · S/N 21058101 N3602YMissionary Aviation Repair Center · Soldotna, AKBuilt 1962 · S/N 21058102 N3603YCarter Duane Lee · Madison, GABuilt 1962 · S/N 21058103 N3605YVita Clean Services · Wenatchee, WABuilt 1962 · S/N 21058105 N3607YHlavnicka Timothy D · Haines, AKS/N 21058107 N3614YEmission -Air Inc · Lexington, NCBuilt 1962 · S/N 21058114 N3616YAnderson Dana R · Redding, CABuilt 1962 · S/N 21058116 N3617YSchindele Micheal D · Tolna, NDBuilt 1962 · S/N 21058117 N3619YWilliams Jimmy Z · Sherman, TXBuilt 1962 · S/N 21058119 N3621YRegistered aircraftBuilt 1963 · S/N 21058121 N3626YNb Ag Solutions Inc · Manila, ARBuilt 1963 · S/N 21058126 N3627YBarber Michael · Pagosa Springs, COS/N 21058127 N3636YMorales Peter · Lake Worth, FLBuilt 1963 · S/N 21058136 N3639YMurphys Flying Service LLC · Quitman, GABuilt 1963 · S/N 21058139 N3646YAerohawk Aviation Inc · Idaho Falls, IDBuilt 1963 · S/N 21058146 N3652YMokhtari Rasoul · Nashville, TNBuilt 1963 · S/N 21058152 N3657YSims Daniel G · Martinez, CABuilt 1963 · S/N 21058157 N3658YJo Co Inc · Knoxville, TNBuilt 1963 · S/N 21058158 N3659YPeterson Laurel R · Hart, MIBuilt 1963 · S/N 21058159 N3663YBrown Robert Scott · Troutman, NCBuilt 1963 · S/N 21058163 N3665YJ & B Airlift LLC · Rupert, IDBuilt 1963 · S/N 21058165 N3667YAir Wake Aviation LLC · Hazelwood, MOBuilt 1963 · S/N 21058167 N3670YRoussin David G · Newville, ALBuilt 1963 · S/N 21058170 N3672YN3672y LLC · Ferrysburg, MIBuilt 1963 · S/N 21058172 N3675YShettle Jay E · Berryville, VABuilt 1963 · S/N 21058175 N3678YDozier Zach J · New Boston, TXBuilt 1963 · S/N 21058178 N3681YJeff Blue Corp · Seminole, FLS/N 21058181 N3685YWhite Lawrence L III · La Habra, CABuilt 1963 · S/N 21058185 N3686YEllis Air LLC · Acworth, GAS/N 21058186 N3688YHarris Beth · Albuquerque, NMS/N 21058188 N3691YHunt Lynn C Trustee · Windsor, CAS/N 21058191 N3694YScott Dale D · Alliance, OHBuilt 1963 · S/N 21058194 N3695YAffordable Aviation Corp · Moriches, NYBuilt 1963 · S/N 21058195 N3699YAmfreight Logistics LLC · Deltona, FLBuilt 1963 · S/N 21058199 N3703YWilemon Ronald J · Tulsa, OKBuilt 1963 · S/N 21058203 N3705YMunoz Concepcion · Tulsa, OKBuilt 1963 · S/N 21058205 N3706YAlexander Steve Craig · Shreveport, LABuilt 1963 · S/N 21058206

Back to AD 76-14-07 R2