AD 72-01-01

Registered aircraft · 198

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

N8545RJohnson Bruce M · Schertz, TXBuilt 1966 · S/N 4307N8547RPeterson Amy L · Boulder City, NVBuilt 1966 · S/N 4309N8548RTri State Air Motive LLC · Berryville, ARBuilt 1966 · S/N 4310N8804RGouldsmith Marlene S · Rose Hill, KSBuilt 1959 · S/N 4156N8805REvans James · Tuolumne, CABuilt 1959 · S/N 4157N8808RSloan David J · Anchorage, AKBuilt 1960 · S/N 4204N8809RBon Aero LLC · Bonaire, GAS/N 4161N8811RBloch Christopher P · Grand Rapids, MIBuilt 1959 · S/N 4163N8817RTrottier Bryan P · Hilltop Lakes, TXBuilt 1959 · S/N 4169N8833RFox Craig · Carnelian Bay, CABuilt 1960 · S/N 4187N8839RHuisman Aero LLC · Clarksville, IAS/N 4193N8846RReynolds Robert B · Amarillo, TXS/N 4200N8849RDyson James R · Hilltop Lakes, TXBuilt 1960 · S/N 4203N8852RWright Duane R · Big Bear City, CABuilt 1960 · S/N 4211N8857RSwanland Robert C · San Jose, CABuilt 1960 · S/N 4217N8861RBarrett Brian W · Bellevue, WABuilt 1960 · S/N 4222N8864RInternational Air Services Inc Trustee · Carson City, NVBuilt 1961 · S/N 4226N8867RWamego William O · Glenpool, OKBuilt 1962 · S/N 4229N8879RWamego Wiliam O · Glenpool, OKBuilt 1965 · S/N 4241N8886RLohr Keith R · Flint, TXBuilt 1965 · S/N 4248N8889RReiley Jeremy W · Harlingen, TXFirst renewal noticeBuilt 1965 · S/N 4251N8893RBrosh Don · Elizabeth, COS/N 4255N91CESchwartz Stacy L · Windsor, NYBuilt 1969 · S/N 30206N9800BEmery Scott Joseph · Seattle, WABuilt 1958 · S/N 4052N9801BCullman Daniel H · Kent, WABuilt 1958 · S/N 4053N9804BTaonick Aviation Investments Inc · Ormond Beach, FLBuilt 1958 · S/N 4056N9806BLayton Brian E · Wolcott, INBuilt 1958 · S/N 4058N9807BMertesdorf Daniel R · Woodland, CABuilt 1958 · S/N 4059N9809BGuymon Stephen L · Mesa, AZFirst renewal noticeBuilt 1958 · S/N 4061N9810BRegistered aircraftS/N 4062N9811BTarver Kent H · Yuma, AZBuilt 1958 · S/N 4063N9815BBarnes Donald E · Wagener, SCBuilt 1958 · S/N 4067N9818BMiranda Ryan E · Las Vegas, NVBuilt 1958 · S/N 4070N9819BEngesath David H · Duluth, MNBuilt 1958 · S/N 4071N9822BAllen Ken · Shelby, NCBuilt 1958 · S/N 4074N9823BOoi Lucy M · Catlett, VAS/N 4075N9824BMckee Shane D · Fairbanks, AKS/N 4076N9826BLaird Charles L · Adelanto, CABuilt 1958 · S/N 4078N9831BOxford Sherman D · Flower Mound, TXBuilt 1958 · S/N 4083N9832BMiller Darrell Y · Madras, ORBuilt 1958 · S/N 4084N9833BIcarus Flights LLC · Rising Fawn, GAFirst renewal noticeBuilt 1958 · S/N 4085N9839BCederquist Carl L · Hayden, IDBuilt 1958 · S/N 4091N9841BHoge Aviation LLC · Pipersville, PABuilt 1958 · S/N 4093N9842BRose Jeffrey C · Carmichael, CABuilt 1958 · S/N 4094N9845BWalker Brent L · Meridian, IDBuilt 1958 · S/N 4095N9846BFischer Bruce M · Sun Prairie, WIBuilt 1958 · S/N 4098N9847BLucas Charles G · Elmore City, OKBuilt 1958 · S/N 4099N9849BZatloukal Jan · Payette, IDBuilt 1958 · S/N 4101
Back to AD 72-01-01