OpenAirDocs.org
AD 74-18-06

Registered aircraft · 860

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

N101YTJagt Terrence L · Crestline, CABuilt 1973 · S/N 28-7310080N1023XBickley David R · Pocatello, IDBuilt 1975 · S/N 28-7510074N1177XParrish View Farms · Kenbridge, VABuilt 1975 · S/N 28-7510086N11LYBishop Jay K · Columbus, INBuilt 1964 · S/N 28-10535N123TXGofly Corporation · Port Ewen, NYBuilt 1968 · S/N 28-11108N13RGIsland Piper Llp · St Helena Is, SCBuilt 1972 · S/N 28-7310055N1465HHolland Ray A · Blue Earth, MNS/N 28-7710002N1490XTwin Peaks Holdings · Midvale, UTBuilt 1975 · S/N 28-7510095N14RWJohnston Jeffrey T · Ramsey, MNS/N 28-10217N15152Meyer Kendra · Ankeny, IABuilt 1972 · S/N 28-7310015N15153Kyzer Stacey A · Fort Mill, SCBuilt 1972 · S/N 28-7310016N15171Eckler David L · New Hudson, MIBuilt 1972 · S/N 28-7310018N15177Air Craft Enviromental Sys Inc · Hilton, NYBuilt 1972 · S/N 28-7310019N15200Cash Warren A · Loveland, COBuilt 1972 · S/N 28-7310020N15201Quaintance Kemper A · Culpeper, VABuilt 1972 · S/N 28-7310021N15208Colorado Northwestern Community College · Rangely, COBuilt 1972 · S/N 28-7310022N15219Shoup Michael D · Pierre, SDBuilt 1972 · S/N 28-7310024N15227Plank James M · Sarasota, FLBuilt 1972 · S/N 28-7310025N15251Thompson Roger C · Herndon, VABuilt 1972 · S/N 28-7310027N15265M & P Aviation LLC · Franksville, WIBuilt 1972 · S/N 28-7310028N15266Plane Rents LLC · South Shore, SDBuilt 1972 · S/N 28-7310029N15277Flying Broom LLC · Prescott Valley, AZBuilt 1972 · S/N 28-7310030N15291Olson Jeffrey D · Dawson, MNBuilt 1972 · S/N 28-7310031N15304Smeltzer And Sons Inc · Cape May C H, NJBuilt 1972 · S/N 28-7310032N15355Brandvold Larry J · Fairfield, MTBuilt 1972 · S/N 28-7310037N15358Daffer Jon T · Edgewood, NMBuilt 1972 · S/N 28-7310038N15363Creativity Before Capital LLC · Tampa, FLBuilt 1972 · S/N 28-7310039N15396Nomann Arnold H · Viroqua, WIBuilt 1972 · S/N 28-7310041N15397Boisvert Thomas Michael · Sonoita, AZBuilt 1972 · S/N 28-7310042N15410Simpson Randal L · Missouri City, TXBuilt 1972 · S/N 28-7310043N1541CSwan Russell · Glenside, PABuilt 1963 · S/N 28-10042N15442Buchanan Ethan D · Au Gres, MIBuilt 1972 · S/N 28-7310046N15475Ortega Chris A · Santa Fe, NMBuilt 1972 · S/N 28-7310048N15493Midwest Flying Service Inc · Elgin, NEBuilt 1972 · S/N 28-7310050N15526Reynolds David K · Bastrop, LABuilt 1972 · S/N 28-7310052N15537J & J Aviation LLC · Thedford, NEBuilt 1972 · S/N 28-7310053N15564Santi Cali Aviation LLC · Longwood, FLBuilt 1972 · S/N 28-7310056N15601Wisconsin Fox River Flyers · Milwaukee, WIBuilt 1972 · S/N 28-7310059N15612Bonnette William A · Gill, MABuilt 1972 · S/N 28-7310060N15624Ultimax Inc · Columbus, OHBuilt 1972 · S/N 28-7310061N15645Ripken Robert L · Stockton, CABuilt 1972 · S/N 28-7310063N15655French Creek Holdings LLC · Saratoga, WYBuilt 1972 · S/N 28-7310064N15666Miller Michelle · Las Vegas, NVBuilt 1972 · S/N 28-7310065N15707Brennan Christopher S · Newark, DEBuilt 1972 · S/N 28-7310069N15735235 Aviation LLC · New Smyrna Beach, FLS/N 28-7310071N1579XBuchberger Robert J · Plainfield, WIBuilt 1975 · S/N 28-7510111N15884Fredrickson Ronald C · Woodlake, CABuilt 1972 · S/N 28-7310072N1588XMilligan Reid · Catawba, NCBuilt 1975 · S/N 28-7510087N15901Harbor Aviation LLC · Wilmington, DEBuilt 1972 · S/N 28-7310073N15979Tron Aviation LLC · Newburgh, INBuilt 1973 · S/N 28-7310079
Back to AD 74-18-06