OpenAirDocs.org
AD 86-13-04 R3

Registered aircraft · 18,497

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

N4957ZGuinasso Kimberly Marsh · Reno, NVS/N U20606059N4958QSnider Scott E DBA · Turner, MTBuilt 1976 · S/N 18802692TN4959CDoll House Properties Inc · Chesapeake, VABuilt 1979 · S/N 21063689N495AUCohen Aircraft Leasing & Sales LLC · Dunwoody, GABuilt 2010 · S/N TH-2287N495CDJl Aviation LLC · Crestwood, KYBuilt 2005 · S/N 1605N495CPIris Fliers Inc · Fernandina Beach, FLBuilt 1995 · S/N 29-0058N495GCCunningham John · Naperville, ILBuilt 1981 · S/N E-1876N495KKatmai Air LLC · Anchorage, AKBuilt 1974 · S/N U20602549N495RDCapital Holdings 226 LLC · Naples, FLBuilt 2003 · S/N 42032N495RFStewart Delbert G · Kent, OHBuilt 1973 · S/N 73-30613N495SLAlair Scott C · Pleasanton, CAS/N L2K-167N4960JPonderosa Airtankers LLC · Safford, AZBuilt 1981 · S/N T18803791TN4960KShuck Drilling Co · Edgar, NES/N P21000383N4960UHopkins Breck G · North Little Rock, ARBuilt 1965 · S/N 21058660N4961ELafferty David W · Harrisburg, ORBuilt 1979 · S/N 18503922N4962FEvans Dick G Trustee · Riverside, CABuilt 1966 · S/N U206-0662N4963UAllen Shanda · Aynor, SCBuilt 1965 · S/N 21058663N4964FTeam Builders Inc · Carson City, NVBuilt 1966 · S/N U206-0664N4967FMile Hi Skydivers Inc · Longmont, COBuilt 1966 · S/N U206-0667N4967KBrown Lawson M II DBA · San Diego, CABuilt 1979 · S/N P21000386N4968UGreen Brandon K · Eufaula, ALBuilt 1965 · S/N 21058668N4969UTallgrass Aviation LLC · Sharon Springs, KSBuilt 1965 · S/N 21058669N496CDCirrus Skies LLC · Clayton, MOBuilt 2005 · S/N 1612N496DCB & Pb LLC · Mentor, OHBuilt 2006 · S/N E3741N496DEHegedus Bruce Alan · Anchorage, AKBuilt 1996 · S/N 29-0082N4970MAerotrust Services Corp · Wilmington, DEBuilt 1978 · S/N E-1277N4970QPettis Ag Aviation LLC · Atlantic, IABuilt 1976 · S/N 18802704TN4972FTomahawk Aviation LLC · Reno, NVBuilt 1966 · S/N U206-0672N4972KEastern Stearman Inc Trustee · Leesburg, VABuilt 1980 · S/N P21000388N4972MZenith Air LLC · Salome, AZBuilt 1978 · S/N E-1275N4972QAdams David G · Knoxville, TNBuilt 1978 · S/N 18503591N4973UFlightpath Leasing LLC · Tallahassee, FLBuilt 1965 · S/N 21058673N4976UMoro Jim · Naples, FLS/N 21058676N4977UBaker Bryan D · Anderson, CABuilt 1965 · S/N 21058677N4978CRwr Air Inc · Tok, AKBuilt 1977 · S/N U20603870N4978FLabahn Ty L · Sherwood, ORBuilt 1966 · S/N U206-0678N4978UKempf Rodney G · Eugene, ORBuilt 1979 · S/N U20605180N497ABedell William F H · Church Hill, MDBuilt 1968 · S/N TE-547N497EBFl Scapes Inc · Panama City Beach, FLBuilt 1999 · S/N E-3296N4981CWatson Michael · Dalhart, TXS/N 21063699N4981KCuriel Gabriel · Oakley, CAS/N P21000390N4983UEmerald Coast Entertainment LLC · Lewes, DEFirst renewal noticeBuilt 1984 · S/N 21064846N4984MBas Part Sales LLC · Greeley, COBuilt 1978 · S/N D-10137N4986FStanley Cherri · Pearland, TXS/N U206-0686N4986MLaney Construction Co Inc · Murphy, NCBuilt 1978 · S/N E-1282N4988Marin Miguel A · QuebecBuilt 1979 · S/N P21000415N4988FBielefeld James L · Kenai, AKBuilt 1966 · S/N U206-0688N4989MRistevski Bill · Vacaville, CABuilt 1978 · S/N D-10140N498CDCrew Zen Aviation LLC · Fort Smith, ARBuilt 2005 · S/N 1549N498DASmm Leasing LLC · Camp Verde, AZBuilt 1975 · S/N 310R0278
Back to AD 86-13-04 R3