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.

N898BHPompa Oliver · Tuscon, AZBuilt 1980 · S/N 21064108 N898LMMlm Aviation LLC · Mars Hill, NCBuilt 1977 · S/N 340A0254 N8991GAll Trimmed Out LLC · Pierre, SDBuilt 1977 · S/N 340A0329 N899RCOsprey Aviation LLC · Hamilton, MTBuilt 1978 · S/N U20604808 N89ADClairmont Holdings Vi LLC · St Thomas, VIS/N 402C0115 N89EPBas Part Sales LLC · Greeley, COBuilt 1974 · S/N 21060380 N89KBJet Sense Aviation Aircraft Holdings Corp · Burlington, WIS/N EA-54 N89KPRegistered aircraftBuilt 1979 · S/N 21063501 N8APacific Aviation LLC · Cottage Grove, ORBuilt 1976 · S/N 18502852 N8ADChelsea Build LLC · Brenham, TXS/N EA-359 N8BLPro One Janitorial Inc · Chicken, AKBuilt 1970 · S/N 414-0098 N8CCMag 3 Aviation LLC · Vidor, TXBuilt 1981 · S/N 21064437 N8EYMoore Robert Russel Sr · Austin, TXBuilt 1985 · S/N P21000850 N8FBRichland Aviation Inc · Sidney, MTBuilt 1978 · S/N 402B1372 N8KMWolding Jeffrey D · Ashland, WIBuilt 1974 · S/N 21060260 N8MXMoncrief Rick L · Melba, IDS/N 21062687 N8NURbc Aviation LLC · Hollywood, FLBuilt 1966 · S/N T210-0220 N8SSWeather Modification LLC · Fargo, NDBuilt 1973 · S/N 340-0191 N8SZFinch Stanley F · San Marcos, TXBuilt 1987 · S/N 4608079 N8TMAdvanced Intelligent Computing Inc DBA · Houston, TXBuilt 1980 · S/N TJ-325 N8WWLcam Aviation LLC · Springfield, MOBuilt 1976 · S/N TK-43 N9002VMason Thomas · Lubbock, TXBuilt 1968 · S/N D-8887 N900GMKashtan David L · Mill Valley, CABuilt 1977 · S/N 310R1249 N900SHShadowline Aviation LLC · Wilmington, DEBuilt 1979 · S/N 414A0460 N900TCBlanco James A · El Dorado Hills, CABuilt 1976 · S/N 340A0210 N9026MGlenn Stephen B · Texarkana, TXBuilt 1977 · S/N 21062051 N902BAEcho Charlie LLC · Manvel, NDBuilt 1979 · S/N 414A-0324 N903CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0047 N9046FCenturion Aviation LLC · Lewes, DEBuilt 1979 · S/N 210-63014 N9063MThompson Anthony · Miami, FLBuilt 1971 · S/N 402B-0105 N9079HJoey Os LLC · Darlington, PABuilt 1979 · S/N 21063829 N907JMWright Flight Inc · Tucson, AZS/N 21063665 N9080XNoldin John · Griffith, INS/N 46-8608035 N9083SRobinson Charley C · Guthrie, OKBuilt 1978 · S/N TJ-152 N9083UNashville Malibu Partners LLC · Hendersonville, TNBuilt 1986 · S/N 46-8608039 N9083ZCalder Brothers Corp · Greenville, SCBuilt 1986 · S/N 4608003 N908DBB36 LLC · Winter Park, FLBuilt 2002 · S/N EA-694 N908PScott Kevin · Santa Fe, NMBuilt 2000 · S/N EA-664 N9090JDieppa Pablo F · North Charleston, SCBuilt 1986 · S/N 46-8608049 N9090NPmt Flyers LLC · Amarillo, TXFirst renewal noticeBuilt 1986 · S/N 46-8608050 N9095SPowers Land Management Service Inc · Lyons, INBuilt 1986 · S/N 46-8608061 N9098UGlobal T & E Inc · Mcallen, TXBuilt 1986 · S/N 4608025 N909DCTwin Piston Aviation LLC · Salisbury, NCBuilt 1980 · S/N 340A0998 N909RFPastjo Aviation LLC · Charleston, WVBuilt 1982 · S/N 414A0840 N90DMDel Martin Lp · Spring, TXBuilt 1972 · S/N 340-0048 N90RWWallace Richard · Santa Teresa, NMBuilt 1979 · S/N 21063283 N90TLColorado Aviators LLC · Gypsum, COBuilt 1979 · S/N P21000206 N9100UFly Mcble LLC · Huntsville, ALBuilt 1986 · S/N 4608011 N91025Arctic Aviation Leasing LLC · Anchorage, AKBuilt 1969 · S/N 20700016 N91045Dakota Aircraft Specialists LLC · Hot Springs, SDBuilt 1975 · S/N 414-0623

Back to AD 89-24-01 R1