Registered aircraft · 4,242

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

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:89-24-01-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:89-24-01-R1') ORDER BY n_number

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:89-24-01-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:89-24-01-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.

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:89-24-01-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:89-24-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N68JWBobcat Aviation LLC · South Hutchinson, KSBuilt 1978 · S/N 340A0500 N68KLVoloshin Vitaly · Seattle, WABuilt 1977 · S/N 340A0258 N68MGDreger Dean R · Wilbur, WABuilt 1981 · S/N 21064392 N68MMLetters Inc · Santa Maria, CABuilt 1979 · S/N EA-5 N68NQRounds Dana H · Vacaville, CABuilt 1976 · S/N U20603399 N68TBSmith Ronald A · Los Gatos, CABuilt 1981 · S/N 21064492 N6900XMueller Robert C · Reno, NVBuilt 1977 · S/N 21062392 N6908PSix Six Hotel Corporation · Bangor, PABuilt 1985 · S/N 46-8508062 N6908XSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 46-8508064 N6913TSanders Wes E · Palos Park, ILBuilt 1985 · S/N 46-8508072 N6914YAirgo US Inc · Columbia, MOFirst renewal noticeBuilt 1985 · S/N 46-8508075 N691JHSb Airlines Inc · Wilmington, DEBuilt 1985 · S/N TJ-480 N691WTPvb36 Leasing LLC · Roanoke, TXBuilt 1979 · S/N 340A0703 N69279Alexa Enterprises LLC · Indianapolis, INBuilt 1984 · S/N EA-413 N6927BKryptonite Industries LLC · Golden, COBuilt 1978 · S/N 21062853 N6929BBantam Vision Inc · Monte Vista, COBuilt 1984 · S/N EA-414 N6930CSix26 Aviation LLC · Freeport, FLBuilt 1984 · S/N EA-420 N6930SBurbach Paul J · Waukesha, WIBuilt 1984 · S/N EA-421 N6931RFender Darrell L · Garfield, WABuilt 1967 · S/N T210-0331 N69369Mobarak Motorsports LLC · Singer Island, FLBuilt 1973 · S/N 402B0516 N6939NSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1978 · S/N 21063161 N693BHRed River Cellular Telephone Corp · Texarkana, ARBuilt 1980 · S/N TJ-294 N693TPRight Rudder LLC · Albemarle, NCBuilt 1975 · S/N 414-0624 N69425Zanek Foundation · Wilmington, DEBuilt 1973 · S/N 340-0248 N69433Rsy Corp · Wilmington, DEBuilt 1973 · S/N 340-0254 N69472Rer Of Little Rock Inc · Little Rock, ARS/N 340-0318 N69485Plane N Simple Aviation LLC · Los Angeles, CAS/N 340-0327 N69492Graham Michael · Newnan, GABuilt 1974 · S/N 340-0332 N69506Satko Frank G · Chesapeake, VABuilt 1974 · S/N 340-0343 N69522Kpk Enterprises Inc · Pasadena, CABuilt 1974 · S/N 340-0354 N69542Dirty Side Down LLC · Hobbs, NMBuilt 1974 · S/N 340-0362 N69555Obanion John William · Powder Springs, GABuilt 1974 · S/N 340-0370 N69571Michaels Daniel T · Mars, PABuilt 1973 · S/N 310Q0789 N695ATL And P Air 2 LLC · Lees Summit, MOBuilt 1974 · S/N 340-0344 N695PGTurcaian Export Services Inc · ProvidencialsS/N 401A0114 N695TClay Kennamer Livestock Farms LLC · Hollywood, ALBuilt 1976 · S/N TK-3 N6967NSand Creek Oil & Gas Inc · Edmond, OKBuilt 1979 · S/N 21063177 N6969YTorres Charles O · Riverside, CABuilt 1966 · S/N T210-0150 N696DTRastavan David DBA · La Habra, CABuilt 1973 · S/N 414-0370 N6972NEnns Robert B · Cayucos, CABuilt 1979 · S/N 21063181 N6976NCenturion Capital Partners LLC · Blue Ash, OHBuilt 1979 · S/N 21063185 N6977BCollins Kevin T · Roseville, CABuilt 1978 · S/N 21062862 N6979NArango Jorge · Mcallen, TXBuilt 1979 · S/N 21063188 N6980MPetumenos Timothy James · Anchorage, AKBuilt 1977 · S/N 21062005 N6993NSp Aircraft LLC · Moscow, IDBuilt 1979 · S/N 21063202 N69983Ruble Air LLC · Mechanicsburg, PABuilt 1974 · S/N 310Q1055 N699BBProfi-Vision Inc · Fogelsville, PABuilt 1981 · S/N TJ-334 N699EEMathes Jay B · Ridgecrest, CABuilt 1976 · S/N 21061184 N699TGTkg Aviation Inc · Port Orange, FLBuilt 1978 · S/N 414A0081 N69LEEle Motorsports LLC · Dover, DES/N 21062897

Back to AD 89-24-01 R1