OpenAirDocs.org
AD 69-04-02

Registered aircraft · 22

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

N221AKRegistration Pending · Oakwood, OHRegistration pendingBuilt 1966 · S/N 188-0184N351JKeltz Bennie J · Hillsdale, INBuilt 1968 · S/N 188-0468N3534QLeatherneck Aviation LLC · Billings, MTBuilt 1969 · S/N 188-0484N3561QSales Joe H · Seminole, TXBuilt 1969 · S/N 188-0511N5539SLm Air Patrol Service Inc · Wink, TXBuilt 1966 · S/N 188-0039N58235Collins Wayne J · Lubbock, TXBuilt 1966 · S/N 188-0033N8000VCga Holdings LLC · Kalispell, MTBuilt 1967 · S/N 188-0250N8007VJcr Ag LLC · Frederick, OKBuilt 1967 · S/N 188-0257N8018VLight Flight Ltd · Lehighton, PABuilt 1967 · S/N 188-0268N8080VTri Rotor Spray & Chemical · Ulysses, KSBuilt 1968 · S/N 188-0330N8081VStorm Flying Service LLC · David City, NEBuilt 1968 · S/N 188-0331N8147VSchmitt Rudy · Brookshire, TXBuilt 1968 · S/N 188-0397N8150VSchindler Flying Inc · Neligh, NEBuilt 1968 · S/N 188-0400N8157VReady Aim Flyer LLC · New Castle, DEBuilt 1968 · S/N 188-0407N926LTHall Richard M · Scotland, SDBuilt 1968 · S/N 188-0347N9742VN9742v LLC · Ord, NEBuilt 1966 · S/N 188-0192N9770VPassmore Stephen B · Lacrosse, WABuilt 1967 · S/N 188-0220N9780VCountry Aero LLC · Darwin, MNBuilt 1966 · S/N 188-0230N9807VLazy T Aviation LLC · Ashland, NEBuilt 1966 · S/N 188-0057N9823VSundance Aviation Inc · Moriarty, NMBuilt 1966 · S/N 188-0073N9866VHughes Todd R · Rocky Ford, COBuilt 1966 · S/N 188-0116N9875VSatanta Flying Service Inc · Satanta, KSBuilt 1966 · S/N 188-0125
Back to AD 69-04-02