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.

N9073LRegistration Pending · Munford, TNRegistration pendingBuilt 1970 · S/N 776-70N9073VOlsen Leif C · Richardson, TXBuilt 1968 · S/N 690013N9073WBerg Daryl A · Savage, MNBuilt 1965 · S/N 28-10673N90743Byrne Matthew A · West Allis, WIBuilt 1981 · S/N 0246N90744Central Virginia Aviation Inc · North Dinwiddie, VAS/N 0250N90748Robinson Helicopter Co · Torrance, CABuilt 1982 · S/N 0256N9074DHill Russell DBA · Seminole, TXBuilt 1981 · S/N 0234N9074JEast Kentucky Aviation LLC · Ashland, KYBuilt 1966 · S/N 28-3110N9074LTillotson Bradley T · Loveland, OHBuilt 1970 · S/N 777-70N9074VLounsbury Joseph Jr · Palm Coast, FLBuilt 1968 · S/N 690015N90759Kemp Acquisitions LLC · Lone Jack, MOBuilt 1982 · S/N 0254N9075LSibbernsen William · Omaha, NEBuilt 1970 · S/N 778-70N9075VRankin David W · Bend, ORBuilt 1968 · S/N 690002N9075ZLimbacher Richard A · Stone Creek, OHBuilt 1982 · S/N 0253N90763Apex Aircraft Leasing LLC · Anchorage, AKBuilt 1983 · S/N 17275856N90769Registration Pending · Sterling, AKRegistration pending, pending cancellationBuilt 1963 · S/N 18-7910N9076CEvv Pilots Club Inc · Evansville, INBuilt 1978 · S/N R18200387N9076HBeachy Jonas D · Whittington, ILBuilt 1989 · S/N 11040CN9076JMidvale Flying Club Inc · Midvale, IDBuilt 1966 · S/N 28-3112N9076WAircraft Holding Solutions Owner Trustee · Newark, DES/N 28-10676N9077Lrh Equipment LLC · Pendleton, ORBuilt 1974 · S/N 186N90774Miller Lynn H · Scottsdale, AZS/N 80927N90775Dubois Aviation Inc · Chino, CABuilt 1969 · S/N 039N9077C389 Fifth Street LLC · Placida, FLBuilt 1978 · S/N R18200388N9077DLitzen Guide Service Inc · Kenai, AKBuilt 1958 · S/N 18-6443N9077JStreuer Troy · Smithville, TXBuilt 1966 · S/N 28-3113N9077KPacific Coast Aero Inc · Torrance, CABuilt 1977 · S/N 28-7816188N9077LVeilleux Payton L · Pittsfield, VTBuilt 1970 · S/N 264-71N9077WSmith Dwayne · Manassas, VAS/N 28-10677N90783Rudd Wayne G · Basalt, COBuilt 1982 · S/N 0290N9078DChandelle Ltd · Brighton, COBuilt 1958 · S/N 18-6446N9078JConner W Larry · Los Lunas, NMBuilt 1966 · S/N 28-3115N9078VRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1968 · S/N 690002N9078WWood Trey A · Colorado City, TXS/N 28-10678N9078YParker Ron L · Melissa, TXBuilt 1970 · S/N 18-8908N9079DThomas William C · Blanchardville, WIBuilt 1958 · S/N 18-6447N9079JTestruth Gary R · Coarsegold, CABuilt 1966 · S/N 28-3116N9079NFlorida State College At Jacksonville · Jacksonville, FLBuilt 1982 · S/N 0295N9079TLuther David J Trustee · Saint Maries, IDBuilt 2001 · S/N 001N9079VAbramson Derek J · Lancaster, CABuilt 1968 · S/N 690003N907AGAntique Aircraft And Automobile LLC · Van Alstyne, TXS/N 22-7218N907ALTjm Ventures Inc · Rio Verde, AZBuilt 1996 · S/N S1742N907APWheeler David A · Kennewick, WAS/N AG5B-10001N907AXNeuman Cort J · Palmer, AKBuilt 2022 · S/N 1N907AZN907az LLC · Miami, FLBuilt 1980 · S/N 17274436N907BPBryant Stephen C · Anchorage, AKS/N 22-2431N907BTKramer Michael · Talkeetna, AKBuilt 2015 · S/N 072515N907CCOconnor Lloyd Thomas · Dillingham, AKS/N 9907CCN907CFThumann Wayne E · Weimar, TXBuilt 2010 · S/N CC18-0045N907CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8330
Back to AD 81-18-04 R2