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.

N4073KOtto David L · Lacey, WAS/N P422N4073NBoswinkel Aviation Inc · Wilmington, DEBuilt 1968 · S/N 680031N4073PPidcock Jeffrey R · Gibraltar, MIBuilt 2001 · S/N 109N4073XWakenigg Michael C · Madison, GABuilt 1970 · S/N 5173N40740Veit John · Port Jefferson, NYBuilt 1973 · S/N 28-7405062N40746Flying Vikings Inc · Hayward, CAS/N 28R-7435119N4074THillsboro Aero Academy LLC · Hillsboro, ORBuilt 1991 · S/N 1787N4074VRowberry Spencer · Grantsville, UTBuilt 1995 · S/N 1N4074XSmith Byron L · Payette, IDBuilt 1970 · S/N 5174N40752Jourdan Frank E · Overland Park, KSBuilt 1973 · S/N 28-7425155N40758Charlie Six LLC · Mesa, AZBuilt 1973 · S/N 32-7400022N4075HWessel Paul Rinehardt · Honolulu, HIS/N 12-3506N4075PHolder Jeffrey J · Madison, GABuilt 1958 · S/N 23-1537N4075TCms Land Co · Richmond, TXBuilt 1952 · S/N 18-1857N40767Bart Steven C · Highland, CABuilt 1973 · S/N 28-7405064N40768Trescone Dennis M · Rochester, MIBuilt 1973 · S/N 28R-7435122N4076HSummerskyz Inc · Saint Joseph, ILBuilt 1991 · S/N 1799N4076KAmar James E · Goodyear, AZS/N BC-1N4076MBendza Matthew J · Bonner, MTBuilt 1947 · S/N 12-2958N4076NStewart Jason S · Hornell, NYBuilt 1968 · S/N 680172N4076XAllen Kent E · Jacksonville, ILBuilt 1971 · S/N 5176N40776Third Coast Aircraft LLC · Mobile, ALBuilt 1973 · S/N 28-7425163N4077MSummers Gary D · Rexburg, IDBuilt 1947 · S/N 12-2959N4077ZN4077z LLC · Wasilla, AKBuilt 1964 · S/N 18-8091N40785Plane Fun Inc Tr Trustee · Snellville, GABuilt 1973 · S/N 34-7450079N40787Henrich Perrin · Northridge, CABuilt 1973 · S/N 28-7425164N4078PHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1991 · S/N 1806N4078XEspey Brendan L · Sandy Springs, GABuilt 1970 · S/N 5178N40798Hovnanyan Ari · Woodland Hills, CABuilt 1973 · S/N 28-7415087N4079PN4079p LLC · Peoria, AZS/N 23-1556N4079XRichardson Scott · Grapevine, TXBuilt 1970 · S/N 5179N4079ZNewton James K · Charles Town, WVBuilt 1963 · S/N 18-8093N407AFRuff Brent M · Santa Clarita, CABuilt 1966 · S/N 30-1285N407BWBridgewater State University · Bridgewater, MABuilt 2000 · S/N 17280937N407CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282444N407EBAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11438N407FAStratus Rr LLC · New Castle, DEBuilt 2025 · S/N 28020207N407FDVilkin Peter D · Palo Alto, CABuilt 1990 · S/N 772N407FRRich Carolyn A · Redondo Beach, CABuilt 1997 · S/N 17280234N407FTSlipstream Inc · Cincinnati, OHBuilt 1982 · S/N 28-8216216N407MD9k Air LLC · Newark, DEBuilt 2021 · S/N 172S12764N407MNMaldonado Leopoldo · Paramount, CABuilt 1983 · S/N 407N407SGriffing Flying Service Inc · Port Clinton, OHBuilt 1979 · S/N 28-7990545N407SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12588N407TLBas Part Sales LLC · Greeley, COBuilt 1970 · S/N 28R-7135013N407WBBad Dog Aviation LLC · Wasilla, AKBuilt 1963 · S/N 18-8085N407WYVerdoljak Corey · Homer, AKBuilt 1955 · S/N 18-4192N407XCallahan Ashton G · Homer, AKS/N 7041CN40801Island View Flying Club · Goleta, CAS/N 28-7410049N40803R&Cb Aviation LLC · Shelby, NCBuilt 1941 · S/N 7500
Back to AD 81-18-04 R2