Skip to content

Registered aircraft · 40,471

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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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.

N7947GStearman Field Aircraft Repair LLC · Benton, KSBuilt 1970 · S/N 17259647 N7947PThorpe Jack · Raleigh, NCBuilt 1962 · S/N 24-3183 N79482Matacotta Ernest A · Marietta, GABuilt 1969 · S/N 17258123 N79488Nevels Steven D · Merritt Island, FLBuilt 1969 · S/N 17258126 N79489Maisonet Gonzalez Hector W · Ocala, FLBuilt 1969 · S/N 17258127 N7948NHayes William B · Saint Charles, MOBuilt 1969 · S/N 28-5364 N7948WCruse Billy · North Bend, WAFirst renewal noticeS/N 28-1992 N7949Thermoking Of Fargo & Isuzu Diesel Midwest · Fargo, NDBuilt 1970 · S/N 18-8882 N79493Bounds Trucking LLC · Faison, NCS/N 17258130 N79498Gord James F · Sandwich, ILBuilt 1969 · S/N 17258132 N79499Johnson Benjamin M · Monroe, WIBuilt 1969 · S/N 17258133 N7949NGuess-Slatosky Carrie · Randleman, NCBuilt 1969 · S/N 28-5365 N794BKMaxlines LLC · Fairfax, CABuilt 1979 · S/N 28-7916556 N79501Skyhawk Flying Club Inc · Omaha, NEBuilt 1969 · S/N 17258134 N79506Allen Michelle E · Sebastopol, CABuilt 1969 · S/N 17258138 N7950GRotormate LLC · Royse City, TXBuilt 1970 · S/N 17259650 N79513Kalman Engineering Inc · Pekin, ILBuilt 1969 · S/N 17258142 N79514Galaxy Aviation LLC · Nantucket, MABuilt 1976 · S/N 17268134 N7951F1world Aero LLC · Fort Meade, MDBuilt 1976 · S/N 28-7715249 N7951WHerman Eric M · Hugo, MNBuilt 1964 · S/N 28-1998 N79526Evink Bradley D · North Branch, MNBuilt 1969 · S/N 17258151 N79529Elliott Tina L · Tucson, AZBuilt 1969 · S/N 17258154 N79531Newberry Tyler D · Clovis, CABuilt 1969 · S/N 17258155 N79533Eby William J · Sugar Grove, ILBuilt 1969 · S/N 17258156 N7953CFox Victor Aircraft & Sales LLC · Lebanon, TNBuilt 1975 · S/N 28-7625090 N7953WMcdaniel James D · Ortonville, MIBuilt 1964 · S/N 28-2001 N79540Funk Kathryn A · Rockledge, FLBuilt 1969 · S/N 17258160 N79543Registration Pending · Manns Harbor, NCRegistration pendingBuilt 1969 · S/N 17258163 N79546Diakonis Emmanuel W · Maumee, OHBuilt 1969 · S/N 17258165 N79549Triad Aviation Academy LLC · Greensboro, NCBuilt 1969 · S/N 17258168 N7954GNo Squawks LLC · Newcastle, CABuilt 1970 · S/N 17259654 N7954NW8s Enterprises LLC · Stillwater, OKBuilt 1969 · S/N 28-5370 N79554Williams Kenneth J · Wasilla, AKBuilt 1969 · S/N 17258171 N79558Silver Creek Aviation Services LLC · Snowflake, AZBuilt 1969 · S/N 17258173 N7955NByrne Daryl K · Eagle, IDBuilt 1969 · S/N 28-5371 N7955WLucas William J · Cochran, GABuilt 1964 · S/N 28-2003 N79562Brown Glynna J · Middlesboro, KYBuilt 1969 · S/N 17258176 N79565Vm Aero LLC · Camden, DEBuilt 1969 · S/N 17258179 N79566Eisele Elton · Schaumburg, ILBuilt 1969 · S/N 17258180 N79567Miller Aviation Group LLC · Coon Rapids, MNBuilt 1969 · S/N 17258181 N7956WBartlett Henry D · Colorado Springs, COBuilt 1964 · S/N 28-2005 N79571Myers James W · Westmoreland, NHS/N 17258185 N79575Fox Valley Flyers Inc · Appleton, WIBuilt 1969 · S/N 17258188 N79576Dillon Monte Lane Trustee · Mooresville, INBuilt 1969 · S/N 17258189 N79578Dannebrock Paul W · Lockport, NYBuilt 1969 · S/N 17258190 N79579Brown Larry · Mesa, AZS/N 17258191 N7957GFlying L Aircraft Inc · Fort Denaud, FLBuilt 1970 · S/N 17259657 N7957WKendry Shane Joseph · Panama City, FLBuilt 1964 · S/N 28-2006 N79580Bowers James H Jr · Broadus, MTBuilt 1969 · S/N 17258192 N79584Ocean Breeze Aviation Inc · Wilton Manors, FLBuilt 1969 · S/N 17258195

Back to AD 80-04-03 R2