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.

N100NJAlba Leasing Services LLC · Scottsdale, AZBuilt 1987 · S/N 3992 N101AEAir Evac Ems Inc · O Fallon, MOBuilt 1980 · S/N 45454 N101DGSummit Helicopters Inc · Salem, VABuilt 1986 · S/N 3929 N102NJUsda Forest Service Fepp · Trenton, NJBuilt 1975 · S/N 1671 N103AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45597 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 N104RTBack Nine Aerial LLC · New Berlin, WIBuilt 1990 · S/N 51364 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 N106AEAir Evac Ems Inc · O Fallon, MOBuilt 1981 · S/N 45566 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 N1075WSan Juan Aviation LLC · Wilmington, DEBuilt 1980 · S/N 45377 N1075YShoreline Aircraft Leasing LLC · Lewes, DEBuilt 1980 · S/N 45378 N1076GHenderson Aviation Co · Junction City, ORBuilt 1979 · S/N 2831 N1078NBank Of Utah Trustee · Salt Lake City, UTBuilt 1980 · S/N 45389 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 N1081KMarks Aviation Group LLC · Lafayette, LABuilt 1980 · S/N 45407 N1084XJefferson County Sheriffs Office · Birmingham, ALS/N 5170 N1085BDel Rio Aviation Inc · Paso Robles, CABuilt 1980 · S/N 2908 N1085TAspen Helicopters Inc · Oxnard, CABuilt 1980 · S/N 45376 N108AEAir Evac Ems Inc · Ofallon, MOBuilt 1981 · S/N 45730 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 N10SPState Of Kentucky · Frankfort, KYBuilt 1983 · S/N 51064 N10TVHelicopters Inc · Cahokia, ILBuilt 1990 · S/N 51399 N110LTLt Aviation LLC · Louisa, KYBuilt 1981 · S/N 45676 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

Back to AD 89-22-01 R1 L