OpenAirDocs.org
AD 73-16-02

Registered aircraft · 33

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:73-16-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:73-16-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.

N12GZBoettcher Aerial Co Inc · Beloit, KSBuilt 1974 · S/N 18801619N21626Low Level Aero LLC · Myakka City, FLS/N 18800917N2279UChristenberry Paul O · Fayette, ALBuilt 1970 · S/N 18800659N37GWillamette Valley Soaring Club · Beaverton, ORBuilt 1966 · S/N 188-0166N4439QLipan Creek Flying Serice LLC · Eola, TXBuilt 1971 · S/N 18800839N44AGVanderpool Gary W · Alamo, TXBuilt 1966 · S/N 188-0138N5508SKimmel Frank S III · Greenwood, MSS/N 188-0008N5517SRussell Charles B · Union City, TNBuilt 1966 · S/N 188-0017N5523SDj Flight Service LLC · Little Falls, MNBuilt 1966 · S/N 188-0023N5642JGreater Houston Soaring Association · Needville, TXBuilt 1969 · S/N 18800592N5647GDarter Lloyd R · Mountain Grove, MOBuilt 1973 · S/N 18801129N5697JRidgway Rick J · Carlisle, INBuilt 1970 · S/N 18800647N685JMBallard Aviation · Waynesville, MOBuilt 1974 · S/N 18801992N6872GVortex Aircrafts Inc · Port Saint Lucie, FLBuilt 1973 · S/N 18801215N8017VThrush Hills LLC · Volga, SDBuilt 1967 · S/N 188-0267N8027VWalton Philip G DBA · Mankato, KSBuilt 1967 · S/N 188-0277N8042VLakeview Aviation Inc · Sanborn, NDBuilt 1967 · S/N 188-0292N8045VGreater Houston Soaring Assoc · Needville, TXBuilt 1967 · S/N 188-0295N8046VSt Bernard Parish Police Jury · Chalmette, LABuilt 1967 · S/N 188-0296N8086VSchmitt Rudy · Brookshire, TXS/N 188-0336N8110VN8110v LLC · Havana, FLBuilt 1968 · S/N 188-0360N8169VNelson Robert L · Fargo, NDBuilt 1968 · S/N 188-0419N9292GDarter Lloyd R · Mountain Grove, MOBuilt 1973 · S/N 18801448N9359GFloyds Flying Service LLC · Wathena, KSBuilt 1973 · S/N 18801457N9725VAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1966 · S/N 188-0175N9753VBellamy Mark A · Freeville, NYBuilt 1966 · S/N 188-0203N9756VLarson Lynn R · Casselton, NDS/N 188-0206N9777VWalker John A · Kotzebue, AKBuilt 1966 · S/N 188-0227N9791VBarazani Jacob J DBA · Chanute, KSBuilt 1966 · S/N 188-0241N9803VKoinzan Enterprises Inc · Elgin, NEBuilt 1966 · S/N 188-0053N9877VBellinger Ag Defense LLC · Manhattan, KSBuilt 1966 · S/N 188-0127N9889VWebb Matthew K · Denton, TXBuilt 1966 · S/N 188-0139N9979GSteinke Matthew R · Gibson, IABuilt 1971 · S/N 18800779
Back to AD 73-16-02