Registered aircraft · 855

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-10-11-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-10-11-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-10-11-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-10-11-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-10-11-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-10-11-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.

N100NJAlba Leasing Services LLC · Scottsdale, AZBuilt 1987 · S/N 3992 N101DGSummit Helicopters Inc · Salem, VABuilt 1986 · S/N 3929 N102NJUsda Forest Service Fepp · Trenton, NJBuilt 1975 · S/N 1671 N103NJUsda Forest Service Fepp · Trenton, NJBuilt 1969 · S/N 361 N104APRock Creek Leasing LLC · Sapulpa, OKBuilt 1990 · S/N 4149 N104RLVertical Vegetation Management LLC · Darlington, INS/N 4315 N104TVFdfah LLC · Chula Vista, CABuilt 1978 · S/N 2379 N105APBearing Tree Land Surveying LLC · Oklahoma City, OKBuilt 1995 · S/N 4381 N105ATQualitair LLC · MichelstadtBuilt 2006 · S/N 4601 N105JDHavens Aviation LLC · Blacklick, OHBuilt 1973 · S/N 1105 N105LHHelilease LLC · Lewes, DEBuilt 1979 · S/N 2185 N105LPEnright Arne P Trustee · Ward Cove, AKBuilt 1980 · S/N 3068 N10699Smith James E Trustee · Kalispell, MTBuilt 1979 · S/N 2857 N106AMJasons Helicopter Services LLC · New Prague, MNBuilt 1974 · S/N 1384 N106JCTrans Peco Aviation LLC · Fort Stockton, TXBuilt 1982 · S/N 3622 N106ZZBrown Helicopter Inc · Pensacola, FLBuilt 1970 · S/N 508 N10729Sale Reported · Philomath, ORSale reported, canceledBuilt 1979 · S/N 2876 N1076GHenderson Aviation Co · Junction City, ORBuilt 1979 · S/N 2831 N1078QAris Leasing Inc · Sunnyvale, CABuilt 1978 · S/N 2425 N1079AN1079a LLC · Missoula, MTBuilt 1980 · S/N 2927 N107GGCarbon River Helicopter Services LLC · Lexington, KYBuilt 1980 · S/N 2917 N107LHHelilease LLC · Lewes, DEBuilt 1978 · S/N 2423 N107PHSouthern Helicopter Service Inc · Millington, TNBuilt 1979 · S/N 2789 N1080NReynolds Aviation LLC · Wills Point, TXBuilt 1981 · S/N 3549 N1084XJefferson County Sheriffs Office · Birmingham, ALS/N 5170 N1085BDel Rio Aviation Inc · Paso Robles, CABuilt 1980 · S/N 2908 N108DRParamount International Inc · Millville, NJBuilt 1976 · S/N 1875 N108LHHelilease LLC · Lewes, DEBuilt 1978 · S/N 2426 N109DXSunwest Construction Enterprises Inc · Tarpon Springs, FLS/N 3489 N109RASunny Sky LLC · Stacyville, IABuilt 1979 · S/N 2741 N109USU S Helicopters Inc · Marshville, NCBuilt 1977 · S/N 2164 N10AJEl Aero Services LLC · Elko, NVBuilt 1980 · S/N 3169 N10KXWhirly Leasing Inc · Richvale, CABuilt 1975 · S/N 1628 N10MSKas Enterprises LLC · Lewes, DEBuilt 1980 · S/N 3208 N110WGMeshoppen Air LLC · Tunkhannock, PABuilt 1978 · S/N 2367 N111BVOceanside Vertical Express LLC · Canaan, NYS/N 3264 N111HFPlane Fun Inc Tr Trustee · Snellville, GABuilt 1968 · S/N 208 N111PMTri Rotor Spray And Chemical · Ulysses, KSBuilt 1975 · S/N 1770 N112LPRanger Aviation Leasing LLC · Wilmington, DES/N 3403 N1158BAir Gov 1 LLC · Rome, NYBuilt 1996 · S/N 4431 N117HKSettan Corp · Goleta, CABuilt 1997 · S/N 4462 N118FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 1991 · S/N 4182 N118TVInterstate Helicopter Inc · Bethany, OKBuilt 1979 · S/N 2844 N11FHD H Helicopter Inc DBA · Sauget, ILBuilt 1993 · S/N 4270 N120LHHelilease LLC · Lewes, DEBuilt 1979 · S/N 2720 N1219WMoes Crop Dusting Service Inc · Marysville, CABuilt 1975 · S/N 1843 N121BT206 Holdings LLC · Spanish Fork, UTS/N 395 N122BTNorth Wind Aviation LLC · Cottage Grove, ORBuilt 1989 · S/N 4053 N122JLotus Aviation LLC · Boring, ORBuilt 1976 · S/N 2035 N123NCNorth Carolina State Highway Patrol · Cary, NCBuilt 1971 · S/N 610

Back to AD 89-10-11 R1