Skip to content

Registered aircraft · 68,369

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

N202TLHafen John Mark Jr Trustee · Woodinville, WABuilt 2002 · S/N 22243 N202TXBaker Wesley D · Las Cruces, NMS/N 92005 N202VABrown Gabriel · Navarre, FLBuilt 2003 · S/N SFG026 N202VFSidetrack Investments LLC · Flowermound, TXBuilt 2002 · S/N 81195 N202VVJeralds Sean K · Prescott, AZBuilt 2012 · S/N 001 N202WGKitchen Thomas M · Indiana, PABuilt 2000 · S/N G-20233 N202WZMeredith Dean J · Boynton Beach, FLBuilt 2000 · S/N 50 N20300Congressional Flying Club Inc · Gaithersburg, MDBuilt 1977 · S/N 17702656 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 N2031CShahen Michael A III · Belleville, ILBuilt 1988 · S/N LAWRENCE0001 N2031QLight Sport Aeronautics LLC · Brooklet, GAS/N 177RG0431 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 N20345Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17261208 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 N2034NNorthstar Aviation Leasing LLC · Merritt Island, FLBuilt 1978 · S/N 15282073 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 N2035QDonn E Mount Realty Inc · Titusville, FLBuilt 1973 · S/N 177RG0435 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 N2036GYoung Robert E · Apple Valley, CAS/N 0214

Back to AD 90-04-06 R1