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.

N55RXJs Enterprises LLC · Clarinda, IABuilt 1981 · S/N 21064586 N560BBSednal Enterprises · Los Gatos, CABuilt 1994 · S/N EA-562 N562DGB2d LLC · Wickenburg, AZBuilt 1976 · S/N 21061684 N564RRAlpha Romeo Aviation LLC · Newark, DEBuilt 1982 · S/N T30300136 N5655CRegistration Pending · Westford, MARegistration pendingBuilt 1980 · S/N 340A0969 N565RAN565ra LLC · Elbert, COBuilt 1977 · S/N 21062347 N567DEclipse Inc · Sharon Springs, KSBuilt 1980 · S/N P21000665 N567DTCenturion Aviation Inc · Kalispell, MTBuilt 1978 · S/N 21062856 N567KCWelch Darrnell M · Hillman, MIBuilt 1987 · S/N 4608071 N5680CSea Spray Aviation LLC · New Smyrna Beach, FLBuilt 1978 · S/N 414A0218 N5688C5688c LLC · Glendale, AZBuilt 1978 · S/N 414A0221 N568HBKurreck Tim R · Caldwell, IDBuilt 1977 · S/N 21061864 N568TWWestray James H · Gainesville, GABuilt 1981 · S/N 340A1252 N5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEBuilt 1979 · S/N 414A0222 N569JMInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0425 N56CMFamily Practice Associates LLC · Ulysses, KSS/N 310R1422 N56DCAero Services Lc · Woods Cross, UTBuilt 1967 · S/N T210-0280 N56GKMatan Kai LLC · West Hollywood, CAS/N 414A0847 N56GLRainosek Kevin · Granbury, TXBuilt 1994 · S/N EA-572 N56HDouble D International LLC · Miami, FLBuilt 1977 · S/N 414-0941 N56MAMinuteman Aviation Inc · Missoula, MTBuilt 1976 · S/N 340A0067 N56TJTrue North Aviation LLC · Leclaire, IABuilt 1981 · S/N 414A0804 N5743JMidwest Aerial Photography · Galloway, OHBuilt 1970 · S/N P20600643 N5757CRoberts Justin · Livingston, MTBuilt 1980 · S/N 340A0975 N575SWHester Thomas F · Santa Barbara, CABuilt 1979 · S/N 414A0268 N5762JJonesco Acquisitions LLC · Bixby, OKBuilt 1971 · S/N 21059462 N5763MStan Hill Aviation LLC · Waterford, MIBuilt 1969 · S/N 310P0063 N5765MBush Abe A · Eatonton, GABuilt 1968 · S/N 310P0065 N5768S3c LLC · Waukee, IABuilt 1972 · S/N 3400037 N577KBDavid A Bush Inc · Hanford, CABuilt 2001 · S/N EA-668 N5793MCoxbill Farms Inc · Torrington, WYBuilt 1969 · S/N 310P0093 N57977Denney Dennis · New Port Richey, FLBuilt 1976 · S/N 21061475 N57AMclallen Holdings LLC · Saint Charles, ILBuilt 1980 · S/N P21000564 N57CXDmdt Ventures LLC · Victor, NYBuilt 1986 · S/N 46-8608013 N57PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0300 N57TWBc & Tw Flying Service LLC · Hot Springs, ARBuilt 1982 · S/N EA-288 N581CBColorado Baron LLC · Ketchum, IDBuilt 1979 · S/N TJ-233 N5825MLee Brian P · Kent, WABuilt 1969 · S/N 310P0125 N5826CBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 402C0050 N5827MHopland Steve · Johnson City, TNBuilt 1972 · S/N 340-0051 N582SBHardy Gordon H · Belmont, CABuilt 1978 · S/N TJ-172 N582TAWiday John P · El Cajon, CABuilt 1979 · S/N TJ-191 N584DSRose Michael · Prescott, AZBuilt 1981 · S/N TJ-343 N584MBCenterline Holdings Inc · Camden, DES/N TK-151 N5858PMatherne David M · Houma, LAS/N TJ446 N5868CShimomura & Co Cpas Pc · New York, NYBuilt 1980 · S/N 340A0977 N5870MMcdonald Brian L · Van Alstyne, TXBuilt 1972 · S/N 3400058 N5878MKodiak Helo LLC · Kodiak, AKBuilt 1972 · S/N 340-0059 N587GFReher David P · Arlington, TXBuilt 1975 · S/N 310R0246 N589RBDukas Air LLC · Fort Lauderdale, FLBuilt 1977 · S/N TJ-89

Back to AD 89-24-01 R1