Skip to content

Registered aircraft · 40,472

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.

N202NYKingsky Flight Academy LLC · Lakeland, FLBuilt 1980 · S/N 17274198 N202PYEastern Stearman Inc Trustee · Leesburg, VABuilt 1978 · S/N 17271126 N202QCooper Brian P · Northport, ALS/N 202 N202RJAydelott James D · Tulsa, OKBuilt 1974 · S/N 17702096 N202SSCarden Dakota L · Montfort, WIBuilt 1988 · S/N 202 N202TXBaker Wesley D · Las Cruces, NMS/N 92005 N202VFSidetrack Investments LLC · Flowermound, TXBuilt 2002 · S/N 81195 N20301Fritz Leslie L · Redgranite, WIS/N 17261174 N20305Fundeen Kelly L · Anchorage, AKBuilt 1972 · S/N 17261176 N2031Hermann Brent D · Okeechobee, FLS/N CW-01 N20310Nine G Aviation LLC · Holdrege, NEBuilt 1972 · S/N 17261180 N20312Cardinal Wings Aviation LLC · Buckner, KYBuilt 1972 · S/N 17261182 N20313Wilde Evan Theodore · Cupertino, CAS/N 17702657 N20314Steinberg Arleen M · Lincoln, MES/N 17261184 N20319Hurlbut Arthur G · Canton, NYBuilt 1972 · S/N 17261188 N20320Seabreeze Aero Club LLC · Wilmington, DEBuilt 1972 · S/N 17261189 N20323Walla Walla University · College Place, WABuilt 1972 · S/N 17261190 N20327Registration Pending · Myrtle Beach, SCRegistration pendingBuilt 1972 · S/N 17261194 N2032LBishop Donald J · Live Oak, FLBuilt 1967 · S/N 365 N20332N20332 LLC · Opa Locka, FLBuilt 1972 · S/N 17261197 N20336Pages Raymond J · Dayton, MDBuilt 1972 · S/N 17261201 N20339Grant David M · Bellingham, WABuilt 1977 · S/N 17702659 N2033CPray Aviation Inc · Augusta, KSBuilt 1959 · S/N TD-203 N2033PAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 23-608 N20341American Patrols Inc · Midland, TXBuilt 1972 · S/N 17261204 N20344Dunbar Martha C · Milford, MABuilt 1972 · S/N 17261207 N20346Hendrych Mark G · Pittsburgh, PABuilt 1972 · S/N 17261209 N20347Salvatori Fred · Atwater, CABuilt 1972 · S/N 17261210 N20348Red Oak Hawks LLC · Red Oak, IABuilt 1972 · S/N 17261211 N2034RPn4 Aviation Holdings LLC · Bishop, CABuilt 1969 · S/N 28-5439 N20352Airspacedfw LLC · Aurora, TXBuilt 1972 · S/N 17261215 N20353Aspen Aviation LLC · Ashland, OHBuilt 1972 · S/N 17261216 N20355N20355 LLC · Ypsilanti, MIS/N 17261217 N20357Skyway Leasing Inc · Lakeland, FLBuilt 1972 · S/N 17261219 N20358Ricky B'S Bodyshop Inc · Berthoud, COBuilt 1977 · S/N 17702661 N2035LChris Fuher Flight Instruction LLC DBA · Townsend, MTBuilt 1967 · S/N 368 N2035ULihs Ashley · Yankton, SDBuilt 1974 · S/N 28-7415467 N20360Jaynair Corp DBA · Middlebury, CTFirst renewal noticeBuilt 1972 · S/N 17261222 N20363Soldan Rafael · Wichita, KSS/N 17261225 N20364Piper Capital Growth Fund LLC · Scottsdale, AZBuilt 1972 · S/N 17261226 N20365Atlas Aero Training LLC · Casper, WYBuilt 1972 · S/N 17261227 N20366Depouli Raymond M · Enumclaw, WABuilt 1972 · S/N 17261228 N20368Beaver Flying Club Inc · Xenia, OHS/N 17261230 N20375May Matthew J · Weatherford, TXBuilt 1977 · S/N 17702664 N20376Kelley Aircraft LLC · Weyers Cave, VABuilt 1972 · S/N 17261237 N20377Moore James E · Arroyo Grande, CABuilt 1972 · S/N 17261238 N2037PKuklo Robert M · Livermore, CABuilt 1956 · S/N 23-614 N20381Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1972 · S/N 17261241 N20382Bass Philip D · Oviedo, FLS/N 17261242 N20384Rutherford Jeffrey L · Montgomery, ALBuilt 1972 · S/N 17261244

Back to AD 80-04-03 R2