Skip to content

Registered aircraft · 8,139

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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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:96-10-01-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.

N7596WSchaefer Hugh W · Merrick, NYBuilt 1964 · S/N 28-1550 N7597RGarces Carlos A · Springfield, VABuilt 1966 · S/N 28-22165 N7598WSmith Cameron · Billings, MTBuilt 1964 · S/N 28-1552 N7599RHoffman Harold O · Andrews, TXBuilt 1966 · S/N 28-22167 N75GPCross Colton · Allons, TNBuilt 1968 · S/N 28-4882 N75GSBright Sky LLC · Orwigsburg, PABuilt 1974 · S/N 28-7405211 N7600WWeigley Kasey Jo · Graham, WABuilt 1964 · S/N 28-1559 N7601WMartinez Frank M · Folsom, CABuilt 1964 · S/N 28-1560 N7603WBe Properties II LLC · North Platte, NEBuilt 1964 · S/N 28-1562 N7605WBrownlow Gail L · Mountain City, TXBuilt 1964 · S/N 28-1564 N7606WOlsen Michael D · Woodinville, WABuilt 1964 · S/N 28-1565 N7609WTaylor Samuel W · Kansas City, MOBuilt 1964 · S/N 28-1568 N7610WMeier Michael D · Naubinway, MIBuilt 1964 · S/N 28-1569 N7611WRace Place Inc · Greenwood, INBuilt 1964 · S/N 28-1571 N7612WGunn Michael Reid · Wilson, ARBuilt 1964 · S/N 28-1572 N7614WFerris Lawrence D · Valentine, NEBuilt 1964 · S/N 28-1575 N7615WBittner Terry L · Woodbine, MDBuilt 1964 · S/N 28-1576 N7617WWhirl'D Helicopters Inc · Sevierville, TNBuilt 1964 · S/N 28-1581 N7618WExaltium Aviation LLC · Baltimore, MDBuilt 1964 · S/N 28-1582 N7621WAlexander Steven W · Kansas City, MOBuilt 1965 · S/N 28-2913 N7622WBarnett Donald R · Atoka, TNBuilt 1964 · S/N 28-1586 N7623WMidwest Heavy Construction LLC · Pleasant Hill, MOBuilt 1964 · S/N 28-1587 N7624WHartley Douglas R · Florence, ALBuilt 1964 · S/N 28-1589 N7625FHarbaugh Steven J · Riverside, CAS/N 28-7725091 N7625WWings Up LLC · Manteno, ILBuilt 1965 · S/N 28-2914 N7626WStiles Kenneth R · Ozawkie, KSBuilt 1964 · S/N 28-1591 N7629WMah Michael · Pittsfield, MAS/N 28-1596 N7631FMatthew E Richards · Southaven, MSS/N 28-7725093 N7631WDyer Troy · Wolcottville, INBuilt 1964 · S/N 28-1599 N7633WBeery Beau · Brockway, MTBuilt 1964 · S/N 28-1602 N7634CGarrison John · Temple, TXBuilt 1975 · S/N 28-7625078 N7635WDependable Aviation LLC · Cartersville, GABuilt 1964 · S/N 28-1604 N7639WWiese Andrew T · Gibsonburg, OHBuilt 1964 · S/N 28-1609 N7640WHine Timothy R · Rogersville, ALBuilt 1964 · S/N 28-1612 N7643WBlasen Matthew C · La Center, WABuilt 1964 · S/N 28-1616 N7644WCatania Robert S · Mooresville, INBuilt 1964 · S/N 28-1617 N7645WGold Rush Air LLC · Anchorage, AKBuilt 1964 · S/N 28-1620 N7647WBeaulaurier Robert N · Walla Walla, WABuilt 1964 · S/N 28-1623 N7649WPatterson Cameron L · Stafford, VAS/N 28-1625 N7652WCarlson Justin Q · Sheridan, WYBuilt 1964 · S/N 28-1629 N7653WHernandez Kelvin · Wilkes Barre, PABuilt 1964 · S/N 28-1630 N7655WRajh Cody · Chino, CABuilt 1964 · S/N 28-1633 N7656WPchg Aviation LLC · Richmond, UTBuilt 1964 · S/N 28-1635 N7657WCrouse David E · Shrewsbury, MABuilt 1964 · S/N 28-1636 N7659WHutain Ronald P · Van Buren, ARBuilt 1964 · S/N 28-1619 N765LBScott Jacob A · Paso Robles, CABuilt 1965 · S/N 282530 N7660WMelberg Bruce W · Weatherford, TXBuilt 1964 · S/N 28-1590 N7661WLund Dana K · West Covina, CABuilt 1964 · S/N 28-1622 N7666WFields Steve · Versailles, MOBuilt 1964 · S/N 28-1644 N7667WRegistration Pending · Hickman, CARegistration pendingBuilt 1964 · S/N 28-1645

Back to AD 96-10-01 R1