OpenAirDocs.org
AD 2022-12-07

Registered aircraft · 85

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
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:2022-12-07')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-12-07')
  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.

N1002ZArnold Sarah D · Benton, TNBuilt 1961 · S/N 984N1047ZDyer Evan H · Ann Arbor, MIBuilt 1964 · S/N 7147N10DVStringer Jeffrey H · Niskayuna, NYBuilt 1963 · S/N 6023N10LSLund Clayton L · Cheboygan, MIBuilt 1963 · S/N 6169N1164Benjamin Kirby · Colorado Springs, COS/N 8542-SHN1196Clayton Harry L · Wichita, KSBuilt 1966 · S/N 8573N11EKEastern Soaring Center Inc · Petersburg, WVBuilt 1972 · S/N 13401N1200Carpenter James M · Harrisburg, NCBuilt 1966 · S/N 6521N1287VNorris Eric Brent · Santa Clara, CAS/N 881N14AAMccarter Group LLC · Helena, MTS/N 13214N154ASFlint River Soaring LLC · Bainbridge, GABuilt 1967 · S/N 13007N1618Knauff & Grove Inc · Julian, PABuilt 1967 · S/N 13033N1679Orion Flugworks LLC · Waterbury Center, VTBuilt 1968 · S/N 13073N170DRReisman William M · Lookout Mountain, TNBuilt 1962 · S/N 8190N1715Burt Compton Enterprises Inc · Marfa, TXBuilt 1967 · S/N 13026N1749Adrian Soaring Club Inc · Ypsilanti, MIBuilt 1967 · S/N 13046N1765Taylor William E · Escanaba, MIBuilt 1967 · S/N 13030N1825Powell Chuck E · Benton, KSBuilt 1967 · S/N 6619N196PLMidwestern Soaring Assoc · Peculiar, MOBuilt 1964 · S/N 6282N221LDutchliar Inc · Wilmington, DES/N 8205N248SDyer Evan H · Ann Arbor, MIS/N 13003N254CJSouthern Eagles Soaring Inc · Butler, GAS/N 8319/AN2720COchsner David W · Clinton Twp, MIBuilt 1957 · S/N 294N3038KPfeiffer Neal J · Wichita, KSBuilt 1966 · S/N 6554N3110Stoia James W · Wagener, SCBuilt 1967 · S/N 13037N3707Kittleson Allen F · Granbury, TXS/N 13087N374TGPeterson Thomas J Jr · Newtown, PABuilt 1961 · S/N 1002N4007UWabash Valley Soaring Association Inc · Lawrenceville, ILBuilt 1964 · S/N 8393N4029ALeonard Steven E · Wichita, KSBuilt 1961 · S/N 944N4099CPasquantonio Raymond · Canton, MIS/N 6058N412XLAbercrombie David R · Eatonton, GABuilt 1967 · S/N 6608N4280AWolfe Donald E · Notasulga, ALBuilt 1961 · S/N 1138N4296CManeely Roy H · Wadsworth, OHBuilt 1965 · S/N 6403N458BKClosson Luke E Jr · Valdosta, GAS/N 6043N4600TDevine Steven C · Doylestown, PAS/N 6315N4637TMetz Stephen V · Stanton, MNBuilt 1964 · S/N 7153N4660SChristman Timothy A · Dayton, OHBuilt 1963 · S/N 8204N4663SClayton Harry L · Wichita, KSS/N 8213N4678SMorrison Scott R · Keizer, ORBuilt 1964 · S/N 8349-SHN4700GSouthern Eagles Soring Inc · Butler, GABuilt 1964 · S/N 7164N4759SSchwartz Louis A · Santa Monica, CABuilt 1964 · S/N 8316N4793TVon Tresckow Peter M · Madison, WIBuilt 1963 · S/N 6141N4938CShockey Jason M · Wharton, TXBuilt 1963 · S/N 6166N5066Markowitz Neal S · Pittsfield, MABuilt 1961 · S/N 958N545TTDyer Evan H · Ann Arbor, MIBuilt 1968 · S/N 13083N5578AFargo Air Museum · Fargo, NDBuilt 1958 · S/N 376N5597AKolberg Rocky · Kelso, WABuilt 1960 · S/N 846N5756DMiner Daniel E · Columbus, OHS/N 247N581AClosson Luke E Jr · Valdosta, GAS/N 7233N582KAPfeiffer Neal J · Wichita, KSBuilt 1958 · S/N 03
Back to AD 2022-12-07