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.

N7845QReading Jared · Uvalde, TXBuilt 1973 · S/N 340-0225 N7858PRegistered aircraftBuilt 1978 · S/N TJ-183 N7864FKeller Russell L · Runaway Bay, TXBuilt 1968 · S/N 4010207 N7875EUniversity Research Foundation · Greenbelt, MDBuilt 1973 · S/N 402B0432 N787AECoordinate Productions LLC · Waterloo, IABuilt 1972 · S/N 21059799 N787AQHiflynal LLC · Harrisburg, ORS/N P21000844 N787DRBad Aire LLC · Aledo, TXS/N 414A0503 N787GSwirsding David J · Chalfont, PABuilt 1979 · S/N 340A0961 N788DMSts Aviation LLC · Daytona Beach, FLBuilt 1978 · S/N 340A0461 N788MAir First LLC · Kalispell, MTBuilt 1986 · S/N 46-8608040 N789BDTroy Farms Lp · Delano, CAFirst renewal noticeBuilt 1973 · S/N 310Q0922 N789FMRadio Flyer LLC · Fox Point, WIBuilt 2000 · S/N EA-652 N789MD340a1021 Inc Trustee · Wilmington, DEBuilt 1980 · S/N 340A1021 N789PTValiair Limited Company · Casper, WYBuilt 1985 · S/N 414A1209 N789SLRoye Bart Laine · Slaton, TXBuilt 1975 · S/N TJ-12 N78BBRadwanski D · Westmont, ILBuilt 1977 · S/N 310R1246 N78BCMastin William · Fort Worth, TXBuilt 1989 · S/N EA-499 N78DGUsac N78dg LLC · Wall Township, NJBuilt 1981 · S/N 414A-0641 N78KC5634 Aviation LLC · Flowery Branch, GABuilt 1978 · S/N 414A-0045 N78KWVolz James R · Laredo, TXBuilt 1974 · S/N U20602647 N78MKNelleh LLC · Liberal, KSBuilt 1978 · S/N 21062587 N78MWSymple Consulting LLC · Topeka, KSBuilt 1976 · S/N U20603205 N78NGRam Aero Development Inc · Waco, TXS/N 414A0617 N78SBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 340-0151 N78UMDenver Air Support Inc · Englewood, COS/N TJ-84 N78WVOrange Motion Trading LLC · Las Vegas, NVBuilt 1977 · S/N 21062214 N7901QKentucky Airmotive Inc · Mount Sterling, KYBuilt 1969 · S/N 401B0001 N7909QSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N 310Q0620 N7912QHagan David · Overgaard, AZBuilt 1969 · S/N 401B0012 N7913QBrown Kevin B · Eureka, MTBuilt 1969 · S/N 401B0013 N793LMJohnson Roger C · Lake Havasu City, AZBuilt 1979 · S/N D-10300 N794PCFlioway LLC · Iowa City, IABuilt 1978 · S/N 414A0098 N7969QBadenhope John R · Greeneville, TNS/N 401B0109 N797HGBearaire LLC · Fairport, NYBuilt 1984 · S/N 46-8408064 N797RACool Air Travel LLC · Macon, GABuilt 1978 · S/N 414A0119 N7983QLorenso Walker Institute Of Technology · Naples, FLBuilt 1971 · S/N 401B0202 N7989QLauritano Stephen G · Goodyear, AZBuilt 1971 · S/N 401B0208 N799ESFive Boys Flight Training LLC · Matthews, NCBuilt 1981 · S/N 414A0657 N799KTAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1976 · S/N U20603580 N79APHigh Tide Aviation LLC · Naples, FLBuilt 1979 · S/N TJ206 N79ASPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N 340A1248 N79BPOrion 207 LLC · Harpswell, MEBuilt 1979 · S/N 414A0263 N79CHPala Angel E · Taos, NMBuilt 1978 · S/N 21062615 N79DCBnb Marine LLC · Miami, FLS/N 414A0212 N79DRMcneill Steve · Santa Fe, NMBuilt 1994 · S/N EA-559 N79DSBonanza Air Ventures LLC · Mammoth Lakes, CABuilt 1982 · S/N EA-326 N79DVDiscovery Associates Inc · Midland, TXBuilt 1979 · S/N P21000233 N79FWDaniel King Aviation LLC · Dover, DEBuilt 1979 · S/N 414A0278 N79PPJon Gibson Co · Cameron Park, CABuilt 1980 · S/N 414A0516 N79RCBach II LLC · Lafayette, LABuilt 1982 · S/N 21064697

Back to AD 89-24-01 R1