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.

N9435LHubbell Aerin B · Mccordsville, INBuilt 1971 · S/N AA1A-0235 N9437LMurrell George E · Glendale, AZBuilt 1971 · S/N AA1A-0237 N9438LM & B Blue Sky LLC · Southlake, TXS/N AA1A-0238 N94397Koenitzer Judson B · Chetek, WIBuilt 1982 · S/N 15285662 N9439LCheung Patrick · Boca Raton, FLBuilt 1971 · S/N AA1A-0239 N943SASunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15279675 N94400Macinnis James Michael · Copley, OHBuilt 1982 · S/N 15285663 N94401Maui Aviators LLC · Pukalani, HIBuilt 1982 · S/N 15285664 N9440LLuedemann Douglas S · Brenham, TXBuilt 1971 · S/N AA1A-0240 N94429Wisconsin Aviation Inc · Watertown, WIBuilt 1982 · S/N 15285669 N94447Flightime LLC · Stuyvesant, NYBuilt 1982 · S/N 15285673 N9444LDiller Aaron J · La Salle, COBuilt 1971 · S/N AA1A-0244 N9446LDiegoli John E · Ashland, ALBuilt 1971 · S/N AA1A-0246 N9448AOlson Ben A · Gig Harbor, WABuilt 1949 · S/N 15269 N9448LCole Douglas W · Kennewick, WABuilt 1971 · S/N AA1A-0248 N9448TSanders Robert · Harlingen, TXS/N 38-78A0103 N94505Riverside Flight Center Inc · Tulsa, OKBuilt 1983 · S/N 15285696 N94513Hampden Aviation Services Inc · Northampton, MABuilt 1983 · S/N 15285702 N9451LWe Fly High LLC · Helena, MTBuilt 1971 · S/N AA1A-0251 N9451TRegistration Pending · Austin, TXRegistration pendingBuilt 1978 · S/N 38-78A0104 N94532Oklahoma State University · Stillwater, OKFirst renewal noticeBuilt 1983 · S/N 15285707 N94553Delta State University · Cleveland, MSBuilt 1983 · S/N 15285718 N9455LNollette Joseph B · Spokane, WABuilt 1971 · S/N AA1A-0255 N94569Chester Charter Inc · Chester, CTBuilt 1983 · S/N 15285731 N94570Richmor Aviation Inc · Hudson, NYBuilt 1983 · S/N 15285732 N94573Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1983 · S/N 15285735 N94577Ace Aircraft Leasing Inc · Nazareth, PABuilt 1983 · S/N 15285736 N94584Sale Reported · West Lafayette, INSale reportedBuilt 1983 · S/N 15285738 N94585Aviation Trade Inc · Castroville, TXBuilt 1983 · S/N 15285739 N94589Haverlock Aircraft LLC · Willoughby, OHBuilt 1983 · S/N 15285740 N9459TAdventures In The Sky Aviation LLC · Fresno, CABuilt 1978 · S/N 38-78A0105 N945KMSkypros East Kansas City · Grain Valley, MOBuilt 1977 · S/N 15280816 N94609Heavy Metal Air LLC · Farmingdale, NYBuilt 1983 · S/N 15285742 N9461LAnthonson Ronald G · Cortland, NYBuilt 1971 · S/N AA1A-0261 N94626New Horizons Aviation Inc · Goshen, INS/N 15285747 N9462LBrake Kevin · Mars, PABuilt 1971 · S/N AA1A-0262 N9464LLehman Logan R · Front Royal, VABuilt 1971 · S/N AA1A-0264 N94652Maryak Hans F · Somersworth, NHBuilt 1983 · S/N 15285752 N94655Iowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1983 · S/N 15285753 N94659Pavco Inc · Gig Harbor, WABuilt 1983 · S/N 15285755 N94661Fjiro Aviation N94661 LLC · Vancouver, WAFirst renewal noticeBuilt 1983 · S/N 15285756 N9466LEastern Slope Aviation Academy · North Conway, NHS/N AA1A-0266 N9467LFanego David · Cape Coral, FLBuilt 1971 · S/N AA1A-0267 N94684Delta State University · Cleveland, MSBuilt 1983 · S/N 15285763 N94688Lyon Aviation Inc · Pittsfield, MABuilt 1983 · S/N 15285765 N9468LGa N9468l LLC · Atlanta, GAS/N AA1A-0268 N9469LButler Mark E · Texarkana, TXBuilt 1971 · S/N AA1A-0269 N946ACNaples Air Center Inc · Naples, FLBuilt 1985 · S/N 15286018 N946MSMt San Antonio College · Walnut, CABuilt 2015 · S/N 1411-2015 N946SFSnohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N 15282353

Back to AD 80-25-02 R2