OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,733

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

N4670VHale Joshua R · Navarre, FLBuilt 1980 · S/N 172RG0360N4670WSezar Hameed Ed · Woodland Hills, CABuilt 1979 · S/N 13307N46713Lochner Richard A · Eagle River, AKBuilt 1968 · S/N 17257446N46715Dillingham Robert S · Soldotna, AKBuilt 1968 · S/N 17257447N46718Webster Steven · Stroudsburg, PABuilt 1968 · S/N 17257449N46719Cabrera Ramon F · Guttenberg, NJBuilt 1968 · S/N 17257450N4671HHall James F · San Luis Obispo, CABuilt 1979 · S/N 24-0806N4671JBoklage Garnett H · Torrance, CABuilt 1968 · S/N 28R-30571N4671RRudder Burt H · Alamo, NVBuilt 1966 · S/N 28-21428N46720Grover Gary R · Grand Marais, MNBuilt 1968 · S/N 17257451N46721Bristol Robert W · Sandpoint, IDBuilt 1968 · S/N 17257452N46722Tingey Brent J · Juneau, AKBuilt 1968 · S/N 17257453N46725Cloud Dancer Aviation Inc · Deland, FLS/N 15283095N46726Taylor David W · Hot Springs, ARBuilt 1968 · S/N 17257455N46729Thomas Mark R · Clintondale, NYBuilt 1968 · S/N 17257457N4672GConcepcion Neftali · Fort Myers, FLS/N 17273298N4672HSmith Alyssa D · Eagan, MNS/N 24-0807N4672JBallard Shu Hui · Rancho Cucamonga, CAS/N 28R-30573N4672QScott Judith M · Spanaway, WAFirst renewal noticeS/N 17261743N46730Zahn Christopher W · Edwardsville, ILBuilt 1968 · S/N 17257458N46731Laurel Highlands Aeronautical Academy LLC · Latrobe, PABuilt 1968 · S/N 17257459N46736Krantz Gwendolyn A · Advance, NCBuilt 1968 · S/N 17257460N46737Berney John E · Morgan Hill, CABuilt 1968 · S/N 17257461N4673RBall Dontel J · Tacoma, WABuilt 1966 · S/N 28-21430N4673ZNeuenburg James A · Clark Fork, IDFirst renewal noticeS/N 22-8206N46742Barlet Richard D · Carthage, MOBuilt 1968 · S/N 17257463N46743Longino Thomas G · Celeste, TXBuilt 1968 · S/N 17257464N46744Harrison Airplane LLC · Cynthiana, KYBuilt 1968 · S/N 17257465N46746Dunlap Gary P · Seattle, WABuilt 1968 · S/N 17257466N46748Roscioli Lamberto · Lighthouse Point, FLBuilt 1978 · S/N 15283098N4674ZHoadley Todd F · Springfield, OHBuilt 1961 · S/N 22-8207N4675JRegistration Pending · Gardnerville, NVRegistration pendingBuilt 1968 · S/N 28R-30576N4675RLatham Cary · Hardin, KYBuilt 1966 · S/N 28-21432N46760Caterinichio Gasper D · Eagle River, AKBuilt 1954 · S/N 18-3907N46762Kay Bennie L · Brigham City, UTBuilt 1978 · S/N 15283102N46764Hatbright Farm LLC · Wilmington, DEBuilt 1954 · S/N 18-3913N4676FSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1976 · S/N 28-7715059N4676PHuslig Brandon M · Carefree, AZBuilt 1960 · S/N 27-205N4676WZaid LLC · Windermere, FLBuilt 1978 · S/N 13252N4676ZNielsen Nancy A · Eugene, ORBuilt 1961 · S/N 22-8209N46773Macannamac Inc · Millinocket, MEBuilt 1954 · S/N 18-3591N46775Lookner Augustus · Owls Head, MEBuilt 1954 · S/N 18-3594N4677RFields Michael L · Rockwood, TNS/N 28-21434N4677SSchutt Michael J · Kimberling City, MOS/N 101N4678PRudloff Uwe K Trustee · Lake Village, INS/N 27-207N4678RRegistration Pending · Vadnais Heights, MNRegistration pendingS/N 28-21436N4678TRothberg Diane Lee · Gainesville, GABuilt 1981 · S/N R18201730N4678ZQrh LLC · Bartlesville, OKBuilt 1961 · S/N 22-8213N46798Shermer Darlene Francis · Brooklyn Park, MNBuilt 1954 · S/N 183327N4679GFlightime Inc · Elkhart, INS/N 17273305
Back to AD 81-18-04 R2