Registered aircraft · 1,179

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-22-01-R1-L') 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-22-01-R1-L') 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-22-01-R1-L')
    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-22-01-R1-L')
  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-22-01-R1-L')
  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-22-01-R1-L')
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.

N97PXIron Horse Aviation LLC · Marshalltown, IABuilt 1984 · S/N 51114 N97RRCounty Of Ocean · Barnegat, NJBuilt 1993 · S/N 4287 N981RHFly Hangar 13 LLC · Mico, TXBuilt 2008 · S/N 4659 N9833FKlump Aviation LLC · Bowie, AZBuilt 1992 · S/N 4205 N988LBUpshaw Roy L · Ft Worth, TXBuilt 1993 · S/N 4217 N98ALAvere LLC · Twin Falls, IDBuilt 1980 · S/N 2985 N98AZBig Tree Aviation LLC · Salem, ORBuilt 1977 · S/N 2296 N98CMSk Hoff Enterprises LLC · Wilsonville, ORBuilt 1989 · S/N 4056 N98EAOn Target Applicators LLC · Monticello, INBuilt 1973 · S/N 935 N98PHOlson Gary Peter · Lanesboro, MNBuilt 1988 · S/N 51254 N98SMLewis Donn C · Millington, MIS/N 658 N9902KSouthmark Aviation Inc · Hattiesburg, MSBuilt 1976 · S/N 1923 N9913KMaine Helicopters Inc · Whitefield, MEBuilt 1976 · S/N 2055 N992MRPlatinum Rigging & Hvac Consulting LLC · Covington, GABuilt 1981 · S/N 3265 N9944KA Scott Jackson Trucking Inc · Jerome, IDBuilt 1976 · S/N 2001 N9953KCoastal Helicopters Inc · Panama City, FLBuilt 1977 · S/N 2150 N995KPBank Of Utah Trustee · Salt Lake City, UTBuilt 1978 · S/N 2572 N996MCT C B Properties Ltd · Wilmington, DEBuilt 1981 · S/N 3273 N996TVTopside Aviation Inc · Brasstown, NCBuilt 1988 · S/N 4019 N9984KJl Aviation Inc · Boring, ORBuilt 1976 · S/N 45054 N9993CTemplar Helicopters LLC · Glendale, AZS/N 45682 N9993KCivil Air Support LLC · Phoenix, AZS/N 2054 N999JHCoastal Equipment Inc · Wellington, FLBuilt 1978 · S/N 2486 N99ZASouthmark Aviation Inc · Hattiesburg, MSFirst renewal noticeBuilt 1979 · S/N 2794 N99ZFFrokjer Greg M · Absarokee, MTBuilt 1977 · S/N 2145 N9QDChemair Helicopters Inc · Jefferson, WIBuilt 1994 · S/N 4306 N9VFAtxaviation LLC · Creedmoor, TXBuilt 1986 · S/N 3945 N9YJHelicopters Inc · Linden, NJBuilt 1982 · S/N 3672 N9ZVL& R Investment Partners LLC · Wilmington, DES/N 3793

Back to AD 89-22-01 R1 L