OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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:80-25-07-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-07-R1')
  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.

N48238Hamilton Brandon T · Morehead, KYBuilt 1979 · S/N 15283306N48239Harrell Robert L · Brooksville, FLBuilt 1979 · S/N 15283307N4823LLaguna Verde Leasing Inc · Wilmington, DES/N 15284233N4823VStratus Air LLC · New Orleans, LAFirst renewal noticeBuilt 1980 · S/N 172RG0391N48241Evans Christopher Warren · Demotte, INBuilt 1979 · S/N 15283308N48244Kelly Kevin J · Lancaster, NYBuilt 1979 · S/N 15283310N4824GHickman Robert B · La Follette, TNBuilt 1979 · S/N 17273372N4824PMikhailau Ivan · Alpine, UTBuilt 1980 · S/N 15284823N4826HIrvin Roy A · Summerville, SCFirst renewal noticeBuilt 1979 · S/N 24-0890N48270Stephenson Christopher J · Rindge, NHBuilt 1979 · S/N 15283315N4827PCarlson Chris · Redwood City, CABuilt 1978 · S/N P21000119N48286Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283320N4828BGc Aviation Services-1 LLC · Miamisburg, OHBuilt 1979 · S/N 15283660N4828KFlywerx LLC · Anchor Point, AKBuilt 1979 · S/N P21000336N4828PFlying Nam LLC · Sheridan, WYBuilt 1981 · S/N 17274828N4829GSoaring Raven LLC · Seattle, WABuilt 1979 · S/N 17273377N4829KCanal Flight LLC · Portland, ORBuilt 1979 · S/N P21000337N4829PBoard Of Trustees Of University Of Illinois · Savoy, ILBuilt 1980 · S/N 15284824N4829RThomas Michael W · Prescott, WABuilt 1978 · S/N R18200614N482ACClarke Jonathan Eric · Eustace, TXBuilt 1999 · S/N 428-99N482EHb Coco & Company · Gonzales, TXBuilt 1979 · S/N 17272338N48306Bargo Marvin Rae Jr · London, KYBuilt 1979 · S/N 15283323N4830BRussell Dwight R · Milo, MEBuilt 1979 · S/N 15283661N4830GHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1979 · S/N 17273378N4830KRamaker LLC · Choteau, MTBuilt 1979 · S/N P21000338N4832TVesely Paul T Trustee · Louisa, VABuilt 1981 · S/N R18201772N48333Central Texas College · Killeen, TXBuilt 1979 · S/N 15283324N48340Candace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 15283326N4834ESweeney Michael J · Seattle, WABuilt 1978 · S/N 17271670N4834KBurke Kenneth V · Payson, AZBuilt 1979 · S/N P21000340N4834QWavra Mark F · East Grand Forks, MNBuilt 1976 · S/N 18802570TN4834SBuell Bay Co · Irvington, VABuilt 1979 · S/N R18201434N4834WParker Larry C · Roswell, NMBuilt 1980 · S/N P21000627N4835GFiedler Aviation LLC · Suffolk, VABuilt 1979 · S/N 17273383N4836GEvolo Aviation LLC · Worthington, OHBuilt 1979 · S/N 17273384N4836SRegistration Pending · Maple Lake, MNRegistration pendingBuilt 1979 · S/N R18201435N4838BAerolina Inc · Hendersonville, NCBuilt 1979 · S/N 15283665N4838KCommercial Tenant Improvement Corp · Alta Loma, CABuilt 1979 · S/N P21000341N4838TSnow Leopard Ltd · Incline Village, NVBuilt 1981 · S/N R18201774N4839GPaw Lifter Aero LLC · Madison, INBuilt 1979 · S/N 17273386N483ACTessos Air Service Inc · Wilmington, DEBuilt 1999 · S/N 1282-99N483EAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N 17273688N48400Vector-USA LLC · Olive Branch, MSBuilt 1979 · S/N 15283332N4840KRyan Craig M · Corona Del Mar, CAS/N P21000342N4840TRegistered aircraftS/N R18201775N48410Azar Suzanne S · El Paso, TXS/N 15280907N4841DDoorglobe Inc · San Francisco, CABuilt 1979 · S/N 17272371N4841RBlack Gulch Aviation LLC · Polson, MTBuilt 1975 · S/N 18802360TN4842KKinetic Group LLC · Eagle, IDBuilt 1979 · S/N P21000343N4842QBlack Gulch Aviation LLC · Polson, MTBuilt 1976 · S/N 18802578T
Back to AD 80-25-07 R1