OpenAirDocs.org
AD 80-02-13

Registered aircraft · 79

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-02-13')
    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-02-13')
  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.

N5UZRick Aviation Inc · Newport News, VABuilt 1980 · S/N 44-8107008N642WPValiair Lc Trustee · Casper, WYBuilt 1997 · S/N 340N6463VFrolander Christopher G · Chugiak, AKBuilt 1966 · S/N 1233N703TGMcneil Otis · Bethlehem, PABuilt 1977 · S/N 13195N7186WHendrix Gregory K · Lindon, UTBuilt 1962 · S/N 28-997N74SBNorman Bradley T · Rosamond, CAFirst renewal noticeS/N 1RJN789FWWalton Marketing Inc · Fort Worth, TXS/N 28820TCN8187HStover James L · Fredericksburg, VABuilt 1980 · S/N 44-8107002N8244QAeroplane Co LLC · Sylvania, OHBuilt 1980 · S/N 44-8107011N82549Airgo Incorporated · Centralia, ILS/N 44-8107015N8254EPerfect Agreements Leasing · Trabucco Canyon, CABuilt 1980 · S/N 44-8107014N8264FRick Aviation Inc · Newport News, VABuilt 1980 · S/N 44-8107027N8269TUniversal Aviators Academy Inc · El Monte, CABuilt 1980 · S/N 44-8107022N8276ASt Cloud Technical & Community College · Saint Cloud, MNBuilt 1980 · S/N 44-8107023N828DMPlane Fun Inc Tr Trustee · Snellville, GABuilt 1982 · S/N MCPHAIL-0001N8303PKh And G LLC · Spring, TXBuilt 1980 · S/N 44-8107031N8333NHill Enterprises Inc Of Delaware · Wilmington, DEBuilt 1981 · S/N 44-8107039N8360VGcgk Air Ventures LLC · Sheridan, WYBuilt 1981 · S/N 44-8107058N83628Gibson Stanley · Draper, UTS/N 44-8107048N8376AN8376a LLC · Orlando, FLBuilt 1981 · S/N 44-8107054N8377LMcmahon Jamin T · Gig Harbor, WABuilt 1981 · S/N 44-8107055N83896Clifford Aviation LLC · Delta, COS/N 44-8107059N838PCGadamic LLC · Fresno, CABuilt 1981 · S/N 448107056N8453XOtto Joel C · Lander, WYBuilt 1981 · S/N 44-8107066N8465BLalaguna Ricardo · Orlando, FLS/N 44-8207003N91GFNew Mexico Dept Of Game And Fish · Santa Fe, NMBuilt 2009 · S/N 454-10/OTCN933JMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1982 · S/N 44-8207009N976MAZephyr Ventures Inc · Wilmington, DEBuilt 1976 · S/N 13043N9DCColeman Jet Solutions LLC · Highland Park, ILBuilt 1982 · S/N 44-8107065
Back to AD 80-02-13