Skip to content

Registered aircraft · 6,348

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.

N1585NTcf Ventures LLC · Wilmington, DEBuilt 1946 · S/N 23117 N1589BWomack Thomas G · Lonoke, ARBuilt 1948 · S/N 6216 N159SKSeacrest Enterprises LLC · Asheville, NCBuilt 1979 · S/N A1520900 N159TGumley Titus G · Wasilla, AKBuilt 1953 · S/N 18-2273 N159TCShooting Star Museum · Devine, TXBuilt 1977 · S/N 15280724 N15AMWhalen John M III · Boise, IDBuilt 1976 · S/N 691173 N15BJTumino Michele R · Tyler, TXS/N 6-6266 N15CJShinar Philip C · California City, CAS/N 1 N15ELCox James L Jr · Rockdale, TXBuilt 1980 · S/N 31126 N15LMKleinert Keith · Alto, GABuilt 1977 · S/N AA1C0116 N15WVWhiskey Victor Aviation LLC · Fairmont, WVBuilt 1969 · S/N 667 N1602GHenry Thomas J · Ellicott City, MDBuilt 1968 · S/N 613 N1603GCp Aviation Inc · Santa Paula, CABuilt 1968 · S/N 609 N1605RGeiger Emory H Jr · Snellville, GABuilt 1976 · S/N AA1B-0605 N1606RStansel Jon S · Conway, ARBuilt 1976 · S/N AA1B-0606 N1607REash Neal S · Louisville, TNBuilt 1976 · S/N AA1B-0607 N1609RJohnson Henry D · Buena Park, CABuilt 1976 · S/N AA1B-0609 N160GBEagle Aviation LLC · Anchorage, AKBuilt 1996 · S/N MBL-001 N160HLProbasco Mitchell L · Floydada, TXBuilt 1946 · S/N 12-1636 N160YAnthonson Ronald G · Cortland, NYBuilt 1971 · S/N AA1A-0048 N1613GInglis Jeffrey R · Hampton, NHBuilt 1968 · S/N 618 N1614GGriffin Donald A · Alma, ILBuilt 1968 · S/N 607 N1616GGorton Trice J · Anchorage, AKBuilt 1968 · S/N 620 N1617GDuch Jose M · Miami, FLBuilt 1968 · S/N 621 N1618GBlue Moon Flying Club LLC · Westminster, MDBuilt 1968 · S/N 622 N1619RNorman Richard L · Dallas, GABuilt 1975 · S/N AA1B-0519 N161GBEagle Aviation LLC · Anchorage, AKBuilt 2015 · S/N MBL-002 N161WMWagner Scott · Cranberry Township, PABuilt 1988 · S/N 1 N1624GBarnett William M · Wasilla, AKBuilt 1968 · S/N 623 N1625RQuebe Jeffrey R · Fort Worth, TXBuilt 1976 · S/N AA1B-0625 N1626RRedman Lee · Moore, OKBuilt 1976 · S/N AA1B-0626 N1627Johns Trevor M · Seattle, WABuilt 2015 · S/N 0021 N1627RRoettger Thomas D · Finksburg, MDBuilt 1976 · S/N AA1B-0627 N1628GBistline Quentin J · Pahrump, NVS/N 626 N1629RMavi Aviation Services LLC · Hickory, NCS/N AA1B0629 N162FKrueger Luke T · Anchorage, AKS/N 15279773 N162PTAero Fliers LLC · Kalispell, MTBuilt 1981 · S/N 15285278 N1632GValentine Robert D · Winfield, KSBuilt 1968 · S/N 627 N1632RRegistered aircraftBuilt 1976 · S/N AA1B-0632 N1633GCarbiener Ross · Kewanee, ILBuilt 1968 · S/N 628 N1633RLawrence Guy A · Bakersfield, CAS/N AA1B-0633 N1634GBruce Robert W · Frontenac, MNBuilt 1968 · S/N 629 N1634RPerrou Jonathan D · Connelly Springs, NCBuilt 1976 · S/N AA1B-0634 N1635RHerrington Luther A · Honey Grove, TXBuilt 1975 · S/N AA1B-0535 N163TKloes Michael L · Everett, WABuilt 1953 · S/N 18-2277 N1643RFoli Rene A · Terre Haute, INBuilt 1976 · S/N AA1B0643 N1647RWildrose Farm & Auto Inc · Lebanon, ORBuilt 1976 · S/N AA1B0647 N1648RKirby John M · Woodstock, GABuilt 1976 · S/N AA1B0648 N1649ROconner Thomas C · Piggott, ARS/N AA1B0649 N164NATaylor Steven · Des Arc, ARBuilt 1978 · S/N 3878A0403

Back to AD 80-25-02 R2