OpenAirDocs.org
AD 85-03-04 R2

Registered aircraft · 340

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:85-03-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:85-03-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.

N5809NN5809n Inc · New Castle, DES/N 14376N5832NWitherington III William A · Newnan, GABuilt 1978 · S/N 14381N583GWGentlemans Investments LLC · Camden, MEBuilt 1978 · S/N 14387N5842NAero Florida LLC · Geneva, FLBuilt 1978 · S/N 14390N5854NShort Brian D · Rock Island, ILBuilt 1978 · S/N 14399N5859NPegasus Flight LLC · Carbondale, ILS/N 14404N5861NTyler Christopher G · Olympia, WABuilt 1978 · S/N 14406N5871NBraun Janet M · Pocono Pines, PABuilt 1978 · S/N 14416N5872NMeans Loren Alonzo III · Wasilla, AKBuilt 1978 · S/N 14417N5877NMeisner Shane · Fredericksburg, VABuilt 1978 · S/N 14422N5879NBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 14424N5WPPhagan Loyce W · Waterford, MIBuilt 1973 · S/N 92N6095ZCoolidge St LLC · Prescott, AZBuilt 1976 · S/N 14005N60JJGauss Karl F · Tully, NYBuilt 1976 · S/N 14175N654NSElks Stephen A · Mountain City, TNBuilt 1974 · S/N 133N675KAAllis Kevin J · Columbia, MDS/N 14152N697RHowland Justin · Pekin, ILS/N 14297N722LWWineberg Lindsay · Beverly Hills, CABuilt 1976 · S/N 14062N723CBPrivateflyer LLC · Lewes, DEBuilt 1978 · S/N 14398N727CJMgr Aviation LLC · Chelsea, MIBuilt 1976 · S/N 14181N735MCd Engineering LLC · Bennington, VTBuilt 1973 · S/N 90N744RCAlki Investments LLC · Texarkana, TXS/N 14401N747TXCognos Consultants LLC · East Palo Alto, CAS/N 14199N762DRC & J Flying LLC · Rapid City, SDBuilt 1978 · S/N 14393N767APHorvath Patrick L · Conyers, GABuilt 1976 · S/N 14097N76QRArmour Approach LLC · Bossier City, LABuilt 1975 · S/N 232N771CBSkycruise Inc · Largo, FLBuilt 1978 · S/N 14378N7PQStarr James Trey · Oklahoma City, OKBuilt 1976 · S/N 14096N8MTGavriilidis Gavriil · Palm Harbor, FLBuilt 1974 · S/N 208N900CDNational Event Entertainment Corp · New York, NYBuilt 1977 · S/N 14213N912JHKelley Joseph S · Trophy Club, TXBuilt 1974 · S/N 228N916MV3b Aircraft Inc Trustee · Wilmington, DEBuilt 1978 · S/N 14359N946RHMorcom Aviation Services Inc DBA · Everett, WABuilt 1977 · S/N 14223N952DGSkywatch Aviation LLC · Leesburg, VABuilt 1977 · S/N 14319N963TBOpdyke Tod J · Concord, CABuilt 1976 · S/N 14158N9682NOhman Chris M · Tulsa, OKS/N 14170N973TSOld Ocean Cattle Co LLC · Sweeny, TXBuilt 1974 · S/N 130N976MAZephyr Ventures Inc · Wilmington, DEBuilt 1976 · S/N 13043N999GMLowe Gary E · Pikeville, KYBuilt 1978 · S/N 14412N999LHRossi Christopher G · Paso Robles, CABuilt 1976 · S/N 13063
Back to AD 85-03-04 R2