Skip to content

Registered aircraft · 17,027

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

N51369Thorn Blake A · Coupeville, WAS/N 15069956 N5136GYork Aviators LLC · York, PAS/N 17258450 N51373Roberts Aviation LLC · Shreveport, LAS/N 15069959 N51374Siekmann David G · Scottsdale, AZBuilt 1968 · S/N 15069960 N51376Reaves Ronald E · Olive Branch, MSBuilt 1968 · S/N 15069962 N51385Taylor William E · Waynesville, MOBuilt 1968 · S/N 15069967 N51386Russell Joseph M J · Douglas, WYBuilt 1977 · S/N 177RG1138 N51389Knudson Tamara M · Deer Park, WABuilt 1968 · S/N 15069970 N51393K&P Flyers LLC · Douglasville, GAS/N 15069974 N51398Twitchell Robert · Jefferson City, MOBuilt 1968 · S/N 15069979 N51400Clark Paul W · Alexandria, MNBuilt 1968 · S/N 15069981 N51401Dowling Connor · Edmonds, WABuilt 1968 · S/N 15069982 N51406Mh Aviation LLC · Le Mars, IABuilt 1968 · S/N 15069987 N51410Good Paul H · Long Island, VABuilt 1968 · S/N 15069990 N51411Lambourne Robert · Pensacola, FLBuilt 1968 · S/N 15069991 N51412Record John W · Apison, TNS/N 15069992 N51415Van Voorhis Adam P · Groton, CTBuilt 1968 · S/N 15069995 N51416Murphy Nicholas Raymond · Kenai, AKBuilt 1968 · S/N 15069996 N51472Breaks Bound LLC · Kalispell, MTBuilt 1966 · S/N 18256977 N5148FBonura Rocco F Jr · Perkinston, MSBuilt 1964 · S/N 17252980 N514TCChildress Anthony H · Frisco, TXBuilt 1973 · S/N 17701995 N5154FGilstrap William D · Catoosa, OKBuilt 1965 · S/N 17253004 N515CLProfessional Pilot Services LLC · Miami, FLS/N 18255135 N51608Commonwealth Of Kentucky · Frankfort, KYBuilt 1967 · S/N R1720255 N5161USkyler Aviation · San Diego, CABuilt 1964 · S/N 206-0161 N5166FColeman Timothy J · Cornwall On Hudson, NYBuilt 1965 · S/N 17253052 N516APStewart Stewart D · South Egremont, MABuilt 1977 · S/N 177-RG-1259 N5173UKnutson Wayne R · Tioga, NDBuilt 1964 · S/N 206-0173 N5178FTurrentine Danny H · Wolfe City, TXBuilt 1965 · S/N 17253100 N5179UPower Flight LLC · Las Vegas, NVBuilt 1964 · S/N 206-0179 N517SAHalo For Freedom Warrior Foundation · Willow Park, TXBuilt 1966 · S/N U206-0644 N517SMMcelvain Pete R · Iowa Park, TXBuilt 1968 · S/N 17257318 N5180FUnited States Air Force Owner · Hanscom Afb, MABuilt 1965 · S/N 17253108 N5180UAssociation Of Baptists For World Evangelism Inc · Harrisburg, PABuilt 1964 · S/N 206-0180 N5182FAmerican Flight Museum Inc · Topeka, KSBuilt 1965 · S/N 17253116 N5184FScott Alan M · Othello, WABuilt 1965 · S/N 17253124 N5186UHumphrey Jeffrey · Corvallis, MTBuilt 1964 · S/N 206-0186 N5188USky Stallion LLC · Winter Park, FLBuilt 1964 · S/N 206-0188 N519Malaska Jacob L · Orefield, PABuilt 1966 · S/N 15064303 N5191URobles Marcos F · Oracle, AZBuilt 1964 · S/N 206-0191 N5193UCox Paul G DBA · Bryce, UTBuilt 1964 · S/N 2060193 N5198UFerguson Kenneth R · Tehachapi, CABuilt 1964 · S/N 206-0198 N519MPUpdike Jesse J · Kenai, AKS/N 17253042 N51MSDekervor Marc Phillippe II · La Mesa, CABuilt 1970 · S/N 17259085 N51WT51 Whiskey Tango LLC · Henrico, VABuilt 1969 · S/N 17258240 N520Registered aircraftBuilt 1977 · S/N 177RG1164 N5200QBas Part Sales LLC · Greeley, COBuilt 1969 · S/N 21059130 N52015Gibbs Timothy L · Valley Grande, ALBuilt 1977 · S/N 177RG1141 N52017Worringer Richard G · Tower, MNBuilt 1977 · S/N 177RG1142 N52019Bryant Robert D · Perry, UTBuilt 1977 · S/N 177RG1143

Back to AD 72-03-03 R3