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.

N612JLHeartland Aviation Inc · Alliance, NES/N 18-7409151N612KSRv Co LLC · Boulder, COBuilt 2010 · S/N 001N612LCGoodman Lawrence A · Granbury, TXBuilt 1969 · S/N 28-26033N612LRBravo Victor Aviation Inc · Keizer, ORBuilt 2021 · S/N 1295N612MRFladr LLC · Westfield, NJBuilt 1979 · S/N 27-8054008N612NPBirdpark Aviation LLC · Richmond, TXBuilt 2003 · S/N 2216N612PAJenkins Phillip R Jr · Fuquay Varina, NCBuilt 1977 · S/N 28-7790518N612PDMenagerie Enterprises Inc DBA · Denison, TXBuilt 2015 · S/N 172S11647N612RANorton Gregory Victor · Petersburg, ILBuilt 2012 · S/N 73479N612RTWolding Mylo D · New Town, NDBuilt 2017 · S/N 82822N612TMMcdermott James Timothy · Newell, SDBuilt 2012 · S/N 1001N612WTPlane Leasing LLC · Tempe, AZBuilt 1978 · S/N 28-7816655N6130DJones Matthew A · Saluda, NCBuilt 1979 · S/N 17272610N6130JUtley Gary D · Okmulgee, OKFirst renewal noticeBuilt 1976 · S/N 28-7615307N6130MKing Mike · Webster, TXFirst renewal noticeBuilt 1980 · S/N 15284627N6130PHiga Bertram · Northridge, CAS/N 24-1230N6130XSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1989 · S/N 7497CN6131JDotson Tem · Hindsville, ARBuilt 1976 · S/N 28-7615308N6131SClassic Rotors Museum · Ramona, CABuilt 1965 · S/N 18-38N6132GMorcom Aviation Services Inc · Everett, WABuilt 1979 · S/N 17273570N6132JWolf Aviation Network Inc · Westfield, MABuilt 1976 · S/N 28-7615309N6132LSale Reported · Charles Town, WVSale reportedBuilt 1970 · S/N AA1-0332N6132VDorsey Russell R · Phoenix, AZBuilt 1980 · S/N 172RG0584N61330Holman Ricardo Earl · Creswell, ORBuilt 1989 · S/N 11065CN6133AReinders Monte M · Port Townsend, WABuilt 1990 · S/N 14001CN6133DThomas Aviation · Granada Hills, CABuilt 1979 · S/N 17272611N6133HCbc Aviation LLC · Hayden, IDBuilt 1979 · S/N 1085-79N6133JArbello Danny · Sterling, VAS/N 28-7615310N6133LBarnett George W · Salem, INBuilt 1970 · S/N AA1-0333N6133NSiesta Key LLC · Wilmington, DES/N M-1216N6134GMagruder David · Independence, LABuilt 1979 · S/N 17273571N6134JBlue Air Training Corp · Las Vegas, NVBuilt 1974 · S/N 08N6134LEuro 2000 Inc · Merritt Island, FLS/N 15284362N6134NChris Bellinger Dvm LLC · Newalla, OKS/N MA-345N6134PJ-Tom Inc · Lincoln, NEBuilt 1959 · S/N 24-1234N6134SPatten Jeffery D · Rapid City, SDBuilt 1965 · S/N 18-41N6134WRegistration Pending · Mesa, AZRegistration pendingBuilt 1964 · S/N 28-20151N6135BOlds Todd · Huntersville, NCBuilt 1978 · S/N 45N6135DHowe Bryan · Edgewater, FLBuilt 1956 · S/N 22-4779N6135QLake Effect Aviation LLC · Java Center, NYBuilt 1981 · S/N 15285159N6135WWhiskey Aviation LLC · Huntsville, ALBuilt 1964 · S/N 28-20152N6136JTennessee Flight Academy LLC · Bristol, TNBuilt 1976 · S/N 28R-7635301N6136KAll On Black LLC · Mount Nebo, WVBuilt 1994 · S/N S1672N6136LTheriot Conchita F · Anderson, SCBuilt 1970 · S/N AA1-0336N6136PPlane Fun Inc Tr Trustee · Snellville, GABuilt 1959 · S/N 24-1236N6137DPhelps Joe · Princeton, KYBuilt 1957 · S/N 22-4781N6137EPennington Mitchell T · Medley, WVBuilt 1978 · S/N 17271994N6137QJeffery & Weiss Holdings LLC · Long Beach, CABuilt 2008 · S/N 172S10682N6137SPiasecki Aircraft Corp · Coatesville, PABuilt 1965 · S/N 18-45N6137TDurnin Timothy K · Lansing, ILS/N R18201917
Back to AD 81-18-04 R2