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.

N67384Flying Twenties Inc · San Jose, CABuilt 1978 · S/N 15281800N67387Florida Flight Training Center Inc · Venice, FLBuilt 1978 · S/N 15281803N6738WRussell Christopher E · Pontotoc, MSBuilt 1965 · S/N 28-20858N67398Jet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N 15281814N6739BDeal Stuart F · Santa Rosa, CABuilt 1956 · S/N 22-4072N6739GHall Lane E · Anthony, FLBuilt 2011 · S/N 72521N6739JRafferty Larry M · Mount Vernon, OHBuilt 1968 · S/N 28-24453N6739NMeyer Ross · Apollo Beach, FLBuilt 1968 · S/N 680187N673ACCook Andrew S · Sheridan, INBuilt 2008 · S/N 2N673ASRodriquez Adrian · Miami, FLBuilt 1978 · S/N 38-78A0285N673CTCentral Texas College · Killeen, TXBuilt 2017 · S/N 2844169N673DTAir Henry LLC · Carthage, MOBuilt 1973 · S/N 28-7410038N673DWSunrise Aviation Inc · Ormond Beach, FLBuilt 1999 · S/N 17280771N673EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12732N673HHaddix Daniel R · Buena Park, CABuilt 2002 · S/N 21673N673JFHall Matthew P · Fowlerville, MIBuilt 1967 · S/N 59N673JHAb Prop Plane II LLC · Metairie, LABuilt 2022 · S/N 172S12900N673LJLegg Daniel T · Knoxville, TNBuilt 1976 · S/N 22-1414N673MALewis University · Romeoville, ILBuilt 1999 · S/N 17280741N673SCSpartan Education LLC · Tulsa, OKBuilt 2021 · S/N 2881438N673SP673sp LLC · Blaine, MNBuilt 2000 · S/N 172S8633N67405Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 15281819N67407Reeb Franklin B · Montross, VABuilt 1978 · S/N 15281820N6740LAslesen Leasin LLC · Halstad, MNBuilt 1974 · S/N 18-7409119N6740NGraham Bruce A · Port Saint Joe, FLBuilt 1968 · S/N 680188N6740UJust Air LLC · Victorville, CABuilt 1963 · S/N 166N67410Sky Chiefs Aviation LLC · Gainesville, FLBuilt 1978 · S/N 15281823N6741BPoehler Fred G · Newberg, ORBuilt 1956 · S/N 22-4074N6741LMountain Aviation Corp · Mccall, IDBuilt 1974 · S/N 18-7409121N6741PBall William E · Amarillo, TXBuilt 1960 · S/N 24-1869N6741TCavanaugh Flight Museum · Denison, TXBuilt 1966 · S/N R-172-0127N67420Coor Colin F · Honolulu, HIBuilt 1978 · S/N 15281827N6742JGannone Nanette V · El Prado, NMBuilt 1968 · S/N 28-24827N6742WMidnight Flight LLC · Wells, TXS/N 28-20863N67431Robinson Candace A · Long Beach, CABuilt 1978 · S/N 15281831N6743FHollywood Biplane LLC DBA · Atlanta, GABuilt 1976 · S/N 28-7715176N6743HCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1975 · S/N 17265562N6743JStader Noah M · Platteville, WIS/N 28-24459N6743NHollingsworth Michael J · Phoenix, AZBuilt 1968 · S/N 680059N6743PFrancis Sean · Pittstown, NJBuilt 1960 · S/N 24-1871N67440Walford Richard M · Shreveport, LABuilt 1978 · S/N 15281835N67443Air-O-Drome Aviation LLC · Caldwell, IDBuilt 1978 · S/N 15281836N67444Odell Eugene S · Yakima, WABuilt 1978 · S/N 15281837N67448Classen Linda · Mustang, OKFirst renewal noticeBuilt 1978 · S/N 15281840N6744NVan Benschoten Mark T · Linwood, MIBuilt 1968 · S/N 680190N6744PGanton Robert B · San Diego, CAS/N 24-1872N6744UMelia Alexander A · Jacksonville, FLBuilt 1963 · S/N 170N6744WSouthwest Flying Club · The Woodlands, TXBuilt 2022 · S/N 18283181N67452Larkin Lucia V · Salome, AZBuilt 1978 · S/N 15281843N6745JHerget Joshua N · Toulon, ILBuilt 1968 · S/N 28-24462
Back to AD 81-18-04 R2