Skip to content

Registered aircraft · 20,683

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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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-06-03-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.

N20272First Class Flying Club LLC · Centennial, COBuilt 1972 · S/N 17261148 N20278Cooke Jerald B · Bowie, AZBuilt 1972 · S/N 17261153 N20279Echevestre Yafet Rivera · Camuy, PRBuilt 1972 · S/N 17261154 N2027YBarnhouse Vicki L · Hurricane, WVBuilt 1962 · S/N 17249527 N20282Fowler Jeffery T · Hopewell, OHBuilt 1972 · S/N 17261156 N20283Positive Attitude Ia Lc · Gaithersburg, MDBuilt 1972 · S/N 17261157 N20286Shenvair LLC · Bridgewater, VABuilt 1972 · S/N 17261159 N20289Whiskey 36 LLC · Norfolk, VABuilt 1972 · S/N 17261162 N20290Payne Larry D · Maryville, TNBuilt 1972 · S/N 17261163 N20291Shergalis William T · Lake Placid, FLBuilt 1972 · S/N 17261164 N20295Adk Flying Club Inc · Ballston Spa, NYBuilt 1972 · S/N 17261168 N20298Hovey Patricia R Trustee · Auxvasse, MOBuilt 1972 · S/N 17261171 N20299Smiley LLC · Clovis, CABuilt 1972 · S/N 17261172 N2029YFox Matthew H · Stony Brook, NYBuilt 1962 · S/N 17249529 N202AJEnterprise Aviation Services LLC · Albuquerque, NMBuilt 2007 · S/N 172S10450 N202AMWalla Walla University · College Place, WABuilt 1975 · S/N 17266213 N202CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12334 N202ENemer-Kaiser Daniel A · Eagle Point, ORS/N 29324 N202NEJepsen William R Trustee · Enterprise, ORBuilt 1976 · S/N 17268104 N202NYKingsky Flight Academy LLC · Lakeland, FLBuilt 1980 · S/N 17274198 N202PYEastern Stearman Inc Trustee · Leesburg, VABuilt 1978 · S/N 17271126 N20301Fritz Leslie L · Redgranite, WIS/N 17261174 N20305Fundeen Kelly L · Anchorage, AKBuilt 1972 · S/N 17261176 N2030CSky Bear LLC · Lakewood, CABuilt 2005 · S/N 172S9941 N2030YStetz Jeri Lynn · Pembroke Pines, FLBuilt 1962 · S/N 17249530 N20310Nine G Aviation LLC · Holdrege, NEBuilt 1972 · S/N 17261180 N20312Cardinal Wings Aviation LLC · Buckner, KYBuilt 1972 · S/N 17261182 N20314Steinberg Arleen M · Lincoln, MES/N 17261184 N20319Hurlbut Arthur G · Canton, NYBuilt 1972 · S/N 17261188 N2031YFluhrer Norman P · Mendocino, CABuilt 1962 · S/N 17249531 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 N2032YBellamy James S · East Canton, OHBuilt 1962 · S/N 17249532 N20332N20332 LLC · Opa Locka, FLBuilt 1972 · S/N 17261197 N20336Pages Raymond J · Dayton, MDBuilt 1972 · S/N 17261201 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 N2034YKirk Petra · Phoenix, AZBuilt 1962 · S/N 17249534 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 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

Back to AD 90-06-03 R1