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.

N98249Tramper Air LLC · Rockford, MIBuilt 1969 · S/N 28-25972 N9824JBarksdale James Alan · Florence, ALBuilt 1980 · S/N 17273925 N9824LSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1986 · S/N 17276624 N9824UPurpose Flight International LLC · Wilmington, DEBuilt 1976 · S/N AA5A0224 N9824VSafety In Motion Flight Center · Puyallup, WABuilt 1974 · S/N 17264516 N98251Wings Over Texas Holdings LLC · Denton, TXBuilt 1984 · S/N 17276269 N98257Fly High Aviation LLC · Miami, FLBuilt 1969 · S/N 28-25954 N9825GKanawha Aviators LLC · Bancroft, WVBuilt 1971 · S/N 17259725 N98263Myers Bobby L · Brookhaven, MSBuilt 1969 · S/N 28-26132 N98265Dickey Hugh B III Dr · Rock Hill, SCBuilt 1969 · S/N 28-26134 N98266Lockhart Ralph E Jr · Beverly, OHBuilt 1969 · S/N 28-26135 N98268Baldassari Roy L · Lawrenceville, NJBuilt 1969 · S/N 28-26137 N98269B&R Aircraft LLC · Wadsworth, OHBuilt 1969 · S/N 28-26138 N9826WWestrup Gregory W · Greensburg, INBuilt 1967 · S/N 28-23329 N98271Mastin Aviation Inc · Pasadena, MDBuilt 1984 · S/N 17276272 N98273Ortner Russell · Apopka, FLBuilt 1969 · S/N 28-26141 N9827DQuality Aviation Inc · Marana, AZS/N 22-6717 N9827GSpencer Jeffrey · Capistrano Beach, CABuilt 1971 · S/N 17259727 N9827UFiedler William K · Greensboro, GABuilt 1976 · S/N AA5A0227 N9827YRegistration Pending · Sweet Home, ORRegistration pending, pending cancellationBuilt 1960 · S/N 50 N9828LJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1986 · S/N 17276625 N9828UAble Gary N · Houston, TXBuilt 1976 · S/N AA5A0228 N98293Je Aircraft Repair LLC · Wasilla, AKBuilt 1969 · S/N 28-26150 N98297Black Hawk Flight Progress LLC · Cedar Falls, IABuilt 1969 · S/N 28-26254 N98298Parsons Mark E · Le Roy, WVBuilt 1969 · S/N 28-26154 N9829JInflight Corp · Chaffee, MOBuilt 1980 · S/N 17273928 N9829YAnderson Isaac · Woods Cross, UTBuilt 1968 · S/N 253 N982SKRowe Andrew L Jr · Hope, MEBuilt 1974 · S/N 17264042 N982YGelm Jack H · Apex, NCBuilt 2004 · S/N 2331 N98308Morse Robert M · Mayetta, KSBuilt 1969 · S/N 28-26162 N9830GGonzalez Nicolas · Naples, FLBuilt 1971 · S/N 17259730 N9830VLeading Edge Flight Academy LLC · Bend, ORBuilt 1974 · S/N 17264518 N98319Restin Air LLC · Kalispell, MTBuilt 1969 · S/N 28-26167 N9831DHiginbotham Larry L · Littleton, COBuilt 1959 · S/N 22-6722 N9831GStarr David · Mount Prospect, ILBuilt 1979 · S/N 17273637 N9831WMeyer Dale K · Altamont, NYS/N 28-23335 N98320Flyg5 LLC · New London, WIBuilt 1969 · S/N 28-26168 N98323Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276277 N98326Lum Barnett K · Temple City, CABuilt 1984 · S/N 17276278 N9832DNimmick Robert A · Three Forks, MTBuilt 1959 · S/N 22-6723 N9832WMcmillin Joey D · Edmond, OKBuilt 1967 · S/N 28-23337 N98335Wiggs Billy L Jr · Fayetteville, NCBuilt 1969 · S/N 28-26174 N9833VMartin Kendall L · Wills Point, TXBuilt 1974 · S/N 17264521 N98345Fly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 28-26178 N98348Industrial Transportation & Distr Consulting LLC · Franklin, OHBuilt 1969 · S/N 28-26179 N9834GNielson Douglas W · East Troy, WIBuilt 1971 · S/N 17259734 N9834LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276628 N9834PScott Dale E · Ava, NYBuilt 1976 · S/N 18-7609034 N9834UN9834u Owners LLC · Lakewood, COS/N AA5A0234 N9834WExceptional Construction LLC · Greenacres, WABuilt 1967 · S/N 28-23340

Back to AD 80-04-03 R2