Skip to content

Registered aircraft · 6,349

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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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.

N9888UTreasure Valley Flying Club LLC · Melba, IDBuilt 1978 · S/N AA1C0150 N9889LBowers Thomas · Grand Terrace, CABuilt 1975 · S/N AA1B-0489 N98900Bruton Jerry C Trustee · Wasilla, AKS/N 12-246 N98912Allen John B · Sutter Creek, CABuilt 1946 · S/N 12-258 N98917Lee Mark D · Palmer, AKBuilt 1946 · S/N 12-268 N98919Gehring Robert A · Rubicon, WIBuilt 1946 · S/N 12-270 N98922Mitchell Mark J · Wrangell, AKFirst renewal noticeBuilt 1946 · S/N 12-275 N98927Deleon Joseph M · Saint Petersburg, FLFirst renewal noticeBuilt 1946 · S/N 12-279 N98932Podeweltz Wayne Leo · Merrill, WIBuilt 1946 · S/N 12-285 N98935Meketa George C · La Vernia, TXS/N 12-290 N9893LStansfield Tod A · Elm Grove, WIBuilt 1974 · S/N AA1B-0493 N98941Flaglor Thomas R · Mosheim, TNS/N 12-296 N98944Phelps Douglas E · Salem, ORBuilt 1946 · S/N 12-299 N9894LHilton Allen J A Jr · Justin, TXBuilt 1974 · S/N AA1B-0494 N98959Delaware Corp · Topping, VABuilt 1946 · S/N 12-313 N98961Knox Norman B · Billings, MTBuilt 1946 · S/N 12-315 N98962Woodward Lowell L · Alpine, TXBuilt 1946 · S/N 12-316 N98965Cook Steven A · Vineland, NJBuilt 1946 · S/N 12-320 N98971Whitaker Eric Lee · Detroit, TXBuilt 1946 · S/N 12-327 N98978Harmon Jon E · Turner, MTBuilt 1946 · S/N 12-335 N98979Mc Bride Robert W Jr · Cedar Park, TXBuilt 1946 · S/N 12-336 N98985Sanker Frank Trustee · Keller, TXBuilt 1946 · S/N 12-342 N98992Mike Pikovsky Aviation LLC · Plymouth, MNBuilt 1946 · S/N 12-350 N98994Lindeen Michael L · Anchorage, AKBuilt 1946 · S/N 12-352 N98999Rodenhouse Robert H · Port Orange, FLBuilt 1946 · S/N 12-360 N989AMcghan Corey A · Big Lake, AKS/N 12-2590 N9900LWalters Linn Robert · Malabar, FLBuilt 1973 · S/N AA1B-0200 N9901LWachsmuth Dawson T · West Ossipee, NHS/N AA1B-0201 N9902UHamaker George E Jr · Birmingham, ALBuilt 1978 · S/N AA1C0153 N9903LAdams Alfred E · Greenville, NCS/N AA1B-0203 N9904LVaughn Jerry Donald · Greer, SCBuilt 1973 · S/N AA1B-0204 N9906TRausch Henry J · Harpers Ferry, WVBuilt 1978 · S/N 38-78A0237 N990KTTridle Keith D · Burlington, WIBuilt 2002 · S/N 1999 N990WYAmelia Reid Aviation LLC · San Jose, CABuilt 1976 · S/N 1168-76 N9910LClingan Charles F · Huddleston, VABuilt 1973 · S/N AA1B-0210 N9912TLang Robert H · Pittsburgh, PABuilt 1978 · S/N 38-78A0241 N9915LHelton James A · Loudon, TNS/N AA1B-0215 N9915TRobinson Christopher Cody · Richmond, KYBuilt 1978 · S/N 38-78A0245 N9916LMauppins Braden · West Memphis, ARBuilt 1973 · S/N AA1B-0216 N9916TRogers Greg · Las Vegas, NVBuilt 1978 · S/N 38-78A0246 N9918LMeggitt Daniel J · Beaufort, NCBuilt 1973 · S/N AA1B-0218 N991ABSand Benjamin P · Koloa, HIBuilt 1980 · S/N WA-79 N991RBSchuerman Rodney L · Anchorage, AKBuilt 1994 · S/N PA-17 N991SWLeston Peter M · Mansfield, MABuilt 2024 · S/N 65-10173 N9922UOwen Christian B · Ontario, CABuilt 1978 · S/N AA1C0156 N9925LNeuroth Kurt V · Saint Charles, MOBuilt 1973 · S/N AA1B-0225 N9925UNguyen Vincent Lam-Son · Fountain Valley, CABuilt 1978 · S/N AA1C0159 N9928LCarpenter Kenneth D · Tempe, AZBuilt 1973 · S/N AA1B-0228 N9931LRivera Carlos · Hiram, GABuilt 1973 · S/N AA1B-0231 N9936LSeng David L · Glade Park, COBuilt 1973 · S/N AA1B-0236

Back to AD 80-25-02 R2