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.

N608FDMjd Yuma Enterprises LLC · Yuma, AZBuilt 1981 · S/N 21064261 N6094BT 210 Telluride Corp · Aspen, COBuilt 1978 · S/N 21062681 N6098XKeystone Aerial Surveys Inc · Philadelphia, PABuilt 1978 · S/N 310R1266 N6099WGriffith Aviation Co · Tulsa, OKBuilt 1981 · S/N P21000713 N609AYAikawa Medical Management Co Inc Trustee · Cheyenne, WYBuilt 2022 · S/N 0920 N609RLT And B Mgmt LLC · Las Vegas, NVBuilt 1979 · S/N 21063802 N60DMDatom Inc · Culver City, CABuilt 1979 · S/N 340A0711 N60DRSudeep Singh Flllp · Clovis, CABuilt 1978 · S/N E-1214 N60DWJohnson Boyd · Apple Valley, MNBuilt 1981 · S/N P21000696 N60EDawson Aircraft Inc · Clinton, ARBuilt 1979 · S/N 340A0663 N60MKAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1981 · S/N P21000670 N60PKWexcap Leasing LLC · Centerville, UTS/N 21064916 N60PPJaams LLC · Shafter, CABuilt 1976 · S/N 340A0073 N60RSVolare Alto LLC · Sanford, NCBuilt 1980 · S/N P21000521 N60SHBas Part Sales LLC · Greeley, COBuilt 1980 · S/N TJ-267 N60WHSan Clemente David Paul · Edgewater, FLBuilt 1976 · S/N 340A0083 N6100YRamsay Allan Trustee · Modesto, CABuilt 1981 · S/N 21064250 N6102WPlane Blessings LLC · Montrose, COBuilt 1981 · S/N P21000715 N6109RBas Part Sales LLC · Greeley, COBuilt 1965 · S/N T210-0009 N610KCU S Imaging Flight Ops LLC · Bartow, FLBuilt 1981 · S/N 21064258 N6112ABarreto Manufacturing Inc · La Grande, ORS/N 21063498 N61170Rusty Pilot Holdings LLC · Citrus Heights, CABuilt 1974 · S/N 21060602 N6119ABrender Ronald F Trustee · West Lafayette, INBuilt 1979 · S/N 21063502 N611CCTjc Productions LLC · Ogden, UTBuilt 1979 · S/N 21063600 N611PGWrightson Properties LLC · Ft Lauderdale, FLBuilt 1985 · S/N 21064911 N611WSFreedom Flight Service LLC · Glendale, AZBuilt 1975 · S/N 21061134 N6126CM20k LLC · Minot, NDBuilt 1978 · S/N 310R1293 N6126YCruise Flight Aviation Inc · Denver, COBuilt 1981 · S/N 21064260 N61275K & K Adventures Inc · Wilmington, DEBuilt 1974 · S/N 21060604 N612JRQ & A Company LLC · Newport, RIBuilt 1980 · S/N 340A0927 N612SFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N 21061651 N612WPRobert A Johnson Construction Lc · High Springs, FLBuilt 1977 · S/N 21062356 N6131AWigen Mary E · Porthill, IDBuilt 1979 · S/N 21063508 N6131XGv Air Inc · Medford, ORS/N 310R1296 N6134ECf Ranch & Cattle Co LLC · Burbank, OHBuilt 1981 · S/N P21000737 N6139BFelker Gary L · Odessa, TXBuilt 1973 · S/N 210-59909 N6151UMccall John A · Grapeland, TXBuilt 1985 · S/N 21064914 N6151YBulloch Troy P · Cedar City, UTS/N 21064269 N6152BMohave County Board Of Supervisors · Kingman, AZBuilt 1978 · S/N 21062724 N6153BCenturion Southeast Management LLC · Raleigh, NCBuilt 1978 · S/N 21062696 N6155YAl & Zal Corp · Wilmington, DEBuilt 1981 · S/N 21064271 N6159ULaw Office Of Vincent G Rieger · Kalispell, MTBuilt 1985 · S/N 21064927 N615PCBurning Blue LLC · Greenwood, MSBuilt 1978 · S/N 340A0615 N615PJEngelstad Dana P · Midland, TXFirst renewal noticeBuilt 1977 · S/N 340A-0260 N615SALordemann Holdings LLC · Kalispell, MTBuilt 1978 · S/N 340A0427 N6161NOn Eagles Wings LLC · Los Gatos, CABuilt 1978 · S/N 21062932 N6161ZSkybound Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0019 N6167CSnyder Larry G · Holland, NYBuilt 1979 · S/N 21063818 N6168NRegistered aircraftBuilt 1978 · S/N 21062939 N616GROld Goat Aviation LLC · Chattanooga, TNS/N TJ-184

Back to AD 89-24-01 R1