OpenAirDocs.org
AD 81-01-08

Registered aircraft · 47

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-01-08')
    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-01-08')
  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.

N1121RAlbert Lea Airport · Albert Lea, MNBuilt 1969 · S/N 125N118RJDodson International Parts Inc · Rantoul, KSBuilt 1976 · S/N 188N150EXDodson International Parts Inc · Rantoul, KSS/N 262N1KTEkfj LLC · Waco, TXBuilt 1978 · S/N 230N2150HCove Pointe Air LLC · Adrian, MIBuilt 1977 · S/N 210N234GAviation Buisness Corp · Saint Louis, MOBuilt 1965 · S/N 28N238DBLewis University · Romeoville, ILBuilt 1977 · S/N 215N26TNAj Air LLC · Blackwell, OKS/N 418N270LCMcnutt Air Partners LLC · Corsicana, TXBuilt 1979 · S/N 245N27TZSparrow Aircorp Inc · Dover, DEBuilt 1977 · S/N 213N299FLAircraft Solutions LLC · Fredonia, WIS/N 435N300TCOrlando Financial Corp · Bear, DEBuilt 1978 · S/N 241N300XL1911 Partners LLC · Rockledge, FLBuilt 1979 · S/N 276N30MRBergen Food Enterprises Inc · Norman, OKBuilt 1978 · S/N 225N316TDBas Part Sales LLC · Greeley, COBuilt 1980 · S/N 312N320MDIsland Jet Aviation Inc · Lewes, DENon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 366N33TWPolytech Adult Education · Woodside, DES/N 316N347GAJp Flying LLC · Dover, DEBuilt 1981 · S/N 347N367WWVmrfalcon50 LLC · Evans, GAS/N 367N386RLKc Aviation Holdings LLC · Tonopah, NVS/N 386N388WWCwj Aviation LLC · Raleigh, NCBuilt 1983 · S/N 388N400GPIcmc Idaho LLC · Salinas, CAS/N 423N418WABorgne Enterprises LLC · New Orleans, LABuilt 1979 · S/N 250N430PTN430pt LLC · Chino, CABuilt 1985 · S/N 430N481NSJp Flying LLC · Dover, DEBuilt 1982 · S/N 378N49CTJog001inc · Lewes, DES/N 314N500BJAir Metro Leasing Inc · Wilmington, DEBuilt 1978 · S/N 242N530DLTaylor Aero LLC · Lewes, DES/N 287N55FGWestwind Air LLC · Canton, GABuilt 1979 · S/N 267N576PVHamilton Victor · Jupiter, FLBuilt 1982 · S/N 383N600KEJuliet Zulu Aviation LLC · Loganville, GABuilt 1985 · S/N 416N600NYNxjets.Net LLC · Wilmington, DEBuilt 1978 · S/N 231N606MAN606ma LLC · Burleson, TXS/N 196N60BTReklaw Management Co · Houston, TXBuilt 1987 · S/N 432N66VAFranco Plastering Inc · Naples, FLBuilt 1983 · S/N 375N696RQAzul Aviation Inc · Burleson, TXS/N 311N711KEN711ke LLC · Wilmington, DEBuilt 1980 · S/N 288N795FMCypress Aircraft Sales LLC · Clermont, FLS/N 228N804CCPappas John · Cave Junction, ORBuilt 1980 · S/N 305N807BFBsdf LLC · La Mesa, CABuilt 1976 · S/N 194N816LCMarklyn Jet Parts LLC · Dallas, TXBuilt 1980 · S/N 291N845TXButler Brian S · Oklahoma City, OKBuilt 1981 · S/N 342N85PTWestwind Air LLC · Oklahoma City, OKBuilt 1980 · S/N 285N890BA818 Operations Inc · Wilmington, DES/N 301N894TWD Jm Holdings LLC · Sugar Land, TXBuilt 1981 · S/N 354N98BMVs Maritime LLC · Oklahoma City, OKBuilt 1976 · S/N 193N9RDFlying Colors Airparts Inc · Leesburg, FLS/N 220
Back to AD 81-01-08